Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Gow to get the datetime() from VFP database server
Message
From
30/08/2002 07:40:59
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
30/08/2002 00:33:24
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00695304
Message ID:
00695355
Views:
10
>Hi All,
>
>Is there a way to get the current datetime() from the VFP database server.
>I have a client talking via ODBC to VFP DBC on the network ( Client/Server app designed in VFP backend is VFP DBC).
>When i create a record using Client i would like to stamp it NOT with DATETIME() from the CLient PC but with datetime() from the VFP server.

One way is to create a file on the server (you can use LLFF: fcreate(), etc.), and get its creation date/time.

I suggest to do this once on startup, and then don't let the user login if the time discrepancy is more than a certain amount of minutes.

HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform