>But that would mean that MySql is running on your local computer, and not on a server. Is this a test environment or you did that in the production environment?

The database is in the server, while MySQL engine is installed in all PCs (server and clients).



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