Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DATETIME() problem.
Message
From
07/08/1998 14:53:30
 
 
To
07/08/1998 12:52:15
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00124841
Message ID:
00124893
Views:
20
Thanks! But I have a question:

I have a table field 'Timestamp', data type is datetime.

I wrote a procedure which will check the value of 'Timestamp' before saving an old record. If current date and time are newer than 'Timestamp', it will replace the record.

'A' workstation runs the procedure at 1:00pm, and 'B' workstation runs it at 
1:01pm. Normally, the value of 'Timestamp' is today and 1:01pm.

But unfortunately, they got the same date, except time. 'A' workstation got 1:00pm, 'B' workstaion got 12:59pm. Although 'B' ran the procedure later, it cannot replace the record forever.

Do I get the current date and time from the server? If yes, how to get them?
KK
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform