Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DATETIME() problem.
Message
From
07/08/1998 15:08:32
 
 
To
07/08/1998 14:53:30
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00124841
Message ID:
00124901
Views:
22
>
>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?
>
What kind of server? Netware? NT?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform