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().