But

Select curdate()
Select localtime()

is the same as

datetime()

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