[FX.php List] Database table modification
jschwartz at exit445.com
Fri May 7 09:11:38 MDT 2010
How about this brute force idea?
Create a unique number field on each record of each table. Add the
numbers in a related table that creates a check sum for your start
date. Rewrite the number if edits are made, which affects the Check
Sum. Missing records also affect the Check Sum.
On another path, consider marking records inactive rather than deleting them.
Hope that helps.
At 11:47 PM -0400 5/4/10, Duncan, Blair wrote:
>Is there any way to get a timestamp of the last modification of a table?
>I'm trying to skip a couple lengthy script steps if no changes have
>been made since the last time it was run.
>Currently I sort on record modification and check the last record
>but If records are removed...no modification timestamp.
>Blair Duncan | Variable Data Manager
>SGL Communications | 2 Bloor St W, Suite 3100 Toronto ON M4W 3R6
>T 416-413-7537 | C 416-845-3357 | F 416-972-5656
Exit 445 Group
jonathan at exit445.com
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the FX.php_List