>
>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?
>
Instead of timestamp you could use an integer value and increment it. You could get the server datetime with winapi but I don't know how to do.
Cetin