AnsweredAssumed Answered

Hi, I would like to check each table in my database to see if there are any new or updated...

Question asked by brian.curran on Dec 4, 2012
Latest reply on Dec 4, 2012 by philmodjunk

Post

     Hi,
     I would like to check each table in my database to see if there are any new or updated records. A dialog box would then be displayed stating whether data had been updated or not for today.

     I tried the following script:


Enter Find Mode [ ]
Set Field [ Site::gz_ModTimeStamp; // *.*.* ]
Set Field [ AlarmCo::gz_ModTimeStamp; // *.*.* ]
Set Field [ Arc::gz_ModTimeStamp; // *.*.* ]
Set Field [ Police::gz_ModTimeStamp; // *.*.* ]
Set Field [ Group::gz_ModTimeStamp; // *.*.* ]
Set Field [ Client::gz_ModTimeStamp; // *.*.* ]
Set Field [ Address::gz_ModTimeStamp; // *.*.* ]
Set Field [ KeySummary::gz_ModTimeStamp; // *.*.* ]
Set Field [ People::gz_ModTimeStamp; // *.*.* ]
Set Field [ SyncJoinPeopleSite::gz_ModTimeStamp; // *.*.* ]
Set Field [ SiteDetailsForDocuments::gz_ModTimeStamp; // *.*.* ]
Set Error Capture [ On ]
Perform Find [ ]

     Unfortunately, the above didn't work! Any suggestions?

     Thanks
     Brian.

Outcomes