Record Changed Flag 1

[tvdbon]

I'm looking for a better way to find out if a record has been updated or if a new record has been inserted. At the moment I'm checking the differences record by record for each table and with a lot of data it does take a while. Any ideas ?

 

[AtomicWedgie]

use triggers

 

[collierd]

Some time back I was looking for something similar

Unfortunately I am told this isn't possible using SQL in its current state, a record by default doesn't hold this info

The only way it can be done (that I am aware of) is to add an extra field (or 2 if you feel the need) which retain the date a record was created/last amended

Every time a record is added/amended update this field

Hope that helps

Damian.

 

[tvdbon]

I had a look at triggers and it seems like it is exaclty what I need. Thanks