Correct
----- Original Message ----- From: "Eric Emminger" <[EMAIL PROTECTED]> To: "Turbine Torque Users List" <[EMAIL PROTECTED]> Sent: Saturday, November 16, 2002 7:52 PM Subject: Re: Foreign-key settings in Schema > 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]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
