Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Compare datetime() of each computer
Message
De
17/06/2021 14:40:31
 
 
À
17/06/2021 08:24:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro et .NET
Divers
Thread ID:
01681219
Message ID:
01681329
Vues:
40
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().
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform