Here I'm pro internet time - getting time per transaction. By a set of IPs provided with the prog. Do not trust system or LAN or DNS.
>In addition to Christians hint, it might be better to add 2 timestamp colums to each CUD statement: timestamp as is set in MySQL and datetime() as set in vfp on client machine. Client time could be altered after program start ;-))
>
>
>>>Just create a file on the server, and check its datetime with Adir().
>>
>>This is a good idea, but I also have a problem.
>>The folder in the server must be R/W in order to be able to write.
>>
>>While I'm using VFP9 with MySQL database, no need to share the server's folder.
>>The server's folder remains ReadOnly
>>
>>Jerry Yang
>>
>>
>>
>>
>>>>in the LAN environment, is there a way to know the server's datetime()?
>>>>
>>>>My client has an issue, the operator changes the clock so he can enter old invoices.
>>>>My client want to each time the cashiers login, the program will compare the datetime() with the server's datetime()
>>>>
>>>>Thanks for the help
>>>>
>>>>Regards,
>>>>
>>>>Jerry Yang
>>>
>>>Just create a file on the server, and check its datetime with Adir().
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]