[FX.php List] Database table modification

[Joel Shapiro]

Hi Blair

You might want to check out FMDiff ( http://fmdiff.com ).  One of the  
things it reports back is the Modified Timestamp per file (although  
I'm not sure if it can get that from files hosted in FMServer or only  
files opened locally).  If the table you want to check is one of many  
in a single file, then it won't give you a Mod. Timestamp per table,  
but if you've got a field set to auto-enter serial numbers, then it  
can report back changes in "RecordChanges" and in  
"nextAutoEnterValue".  There's a free trial version.

HTH,
-Joel

~~~~~~~~~~~~~~~~~~~~~~~
Joel Shapiro
FileMaker Pro
database & web design
http://www.jsfmp.com
415-269-5055
~~~~~~~~~~~~~~~~~~~~~~~


On May 5, 2010, at 10:54 AM, Duncan, Blair wrote:

> The database itself has many relations with child and grandchild  
> records.
> Change in data.
>
>
>
> 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
>
>
> -Original Message-
>
>
>
>
> Are you looking for change in data? or the table definition itself?
>
> ggt
>
> 2010/5/5 Duncan, Blair <Blair.Duncan at bbdo.ca>:
> > 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
> >
> >
> >
> > Please consider the environment before printing this e-mail.
> >
> > This message and any attachments contain information, which may be
> > confidential or privileged. If you are not the intended recipient,  
> please
> > refrain from any disclosure, copying, distribution or use of this
> > information. Please be aware that such actions are prohibited. If  
> you have
> > received this transmission in error, kindly notify us by e-mail to
> > helpdesk at bbdo.com. We appreciate your cooperation.
> >
> >
> >
> >
> >
> > _______________________________________________
> > FX.php_List mailing list
> > FX.php_List at mail.iviking.org
> > http://www.iviking.org/mailman/listinfo/fx.php_list
> >
> >
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
> -Original Message-
>
>
>
> Please consider the environment before printing this e-mail.
>
> This message and any attachments contain information, which may be  
> confidential or privileged. If you are not the intended recipient,  
> please refrain from any disclosure, copying, distribution or use of  
> this information. Please be aware that such actions are prohibited.  
> If you have received this transmission in error, kindly notify us by  
> e-mail to helpdesk at bbdo.com. We appreciate your cooperation.
>
>
>
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list