>>Nope. DateTime() is vfp=client, the others are coming from the SQL server. Log both in the same record - changes of local computer date will be obvious. Also perhaps add server side incremental sequential nr which allows you trace added records from another angle.
>
>I changed the Windows' date to 01/01/2020 10:00
>when I test in MySQL Query Browser:
>

>Select curdate()
>Select localtime()
>

>it shows 01/01/2020 10:00, not the real datetime
>
>Jerry
>
>
>>>But
>>>

>>>Select curdate()
>>>Select localtime()
>>>

>>>is the same as
>>>

>>>datetime()
>>>

>>
>>Nope. DateTime() is vfp=client, the others are coming from the SQL server. Log both in the same record - changes of local computer date will be obvious. Also perhaps add server side incremental sequential nr which allows you trace added records from another angle.
>>
>>>What happens is the operators try to cheat by entering the invoice with back date, hence it's hard to detect. I disabled the invoice date, but they can easily change the computer date so the protection is useless.
>>>
>>>The other way is to compare the datetime() from the client vs the server. because the server is secure and the datetime() is always correct.
>>>
>>>This is in LAN environment and not necessary connect to internet.
>>>
>>>Thanks for the help
>>>
>>>Jerry Yang
>>>
>>>
>>>>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().

In MySQL Workbench I can choose the local Server, or a web server. If I choose the local version of course it will use the local date. There's no other option.
I would expect to expect the web server version to use the remote date.