[FX.php List] Database table modification

[Jonathan Schwartz]

Blair,

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.

Jonathan


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
http://www.exit445.com
415-370-5011
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20100507/8748c90a/attachment.html