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

There is only one database and it's on server.
Not database in each client.



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