Table signature 1

[florindaniel]

Hello,

With a lot of your help (thank you) I've managed to move my App from the server
on each workstation, thus reducing the number of open files across the network. I want
to go further now and move the not-so-often-modified tables locally.

Since one of my Apps is using some relativ static nomenclature tables, I wonder if there's
some way to calculate a kind of signature for that tables in order to detect when they are
modified. Since we are talking about updates, the number of records and/or the creation date
is not working. The idea is to check, at program startup, if there are some updates into
that tables and, if so, to copy them locally.

Thank you,
Daniel

 

[Olaf Doschke]

Last modified date of the dbf would be working.

You could also use record checksums to verify an update per record, see SYS(2017) computing CRC32. Computing an MD5 hash of the whole file would also work, but why the hassle?

FDATE(DBF()) will tell you the last modifed date. And you can also use XCOPY at startup to copy only newer files, as you perhaps did with the EXE file to copy updates of the application itself.

Bye, Olaf.