Colin > On all our tables we have the following columns > > 1. CreationDate & CreatedBy > 2. ModificationDate & ModifiedBy > 3. DeletionDate & DeletedBy > > They are all used to track changes and to help when syncing the data with > another DB, specifically for getting incremental changes. In the Peers we > have a method doSelectActive() which returns those records whereby the > DeletionDate & DeletedBy columns are null. Otherwise the record is marked as > deleted/inActive or as Microsoft would say tombstoned :-) > > So what I'm looking for is a manner to easily mark a record as inActive, and > also the records via foreignKeys associated with that record. Again this > could involve a number of different tables.
This sounds like a reverse relationship. When you mark a record in table A as inActive, you want the related records in tables B, C, and D to update automatically. Is this correct? -- Eric Emminger [EMAIL PROTECTED] -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
