[FX.php List] Database table modification

Jonathan Schwartz 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:
>Content-Class: urn:content-classes:message
>Content-Language: en
>Content-Type: multipart/alternative;
>	boundary="_000_C806629D88BDBlairDuncanbbdoca_"
>Hello list,
>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

Jonathan Schwartz
Exit 445 Group
jonathan at exit445.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20100507/8748c90a/attachment.html

More information about the FX.php_List mailing list