>>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).
>
Sorry, without further explanation this makes no sense at all. Benefit of MySQL / MariaDB / Postgres / Oracle / DB2 / SQL server is to keep all data on one beefy server. Keeping a local data copy on each client and replicating across all machines feels wasteful at least and an accident waiting to happen


,,,,



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