[FX.php List] Database table modification

Gjermund Gusland Thorsen ggt667 at gmail.com
Thu May 6 11:43:05 MDT 2010


You can have a calc field with latest change, but that will probably
reply latest access to the file?

2010/5/6 Joel Shapiro <jsfmp at earthlink.net>:
> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>


More information about the FX.php_List mailing list