Posted by Ed Murphy on 04/13/07 17:00

Hilary Cotter wrote:

> But I'm a little confused - you say " if i see a value on the DeletedDate, I
> don't want that record to be picked up for replication."
>
> But then in the next statement you say "when someone marks the record for
> deletion (by putting a date on the DeleteDate column), I want that record to
> be
> deleted on the subscriber database"
>
> These sound like mutually exclusive statements.

I interpreted the statements as "if DeleteDate is already non-null then
don't replicate" and "if DeleteDate becomes non-null then delete from
subscriber". In particular, a row with DeleteDate non-null might have
some other column changed (in which case it shouldn't be replicated), or
might have DeleteDate set back to null (in which case it should be
replicated).

[Back to original message]