If there is no las updated attribute in a table is there any way of checking when the row was last updated? Thanks Rob
Hi,
A way may be to insert a field timestamp in every record and assign it the time at INSERT...
Yeah, this kinda thing tends to be database dependent since it's usually handled by triggers. There's a code example in the code library for a postgresql update / insert trigger.
For MySQL, there's an exact type that does this, RTM.
Yea I know how to do this, but if this wasn't set up, a row has been changed and I need to find out when it was changed. How can I do this?
you can't.
