PLEASE STOP USING PRE ON YOUR MESSAGESIt causes the text to not wordwrap to the browser window. Only use the tag for posting a code fragment to preseve the indentation.
IE4 has crashed twice now trying to read Craig's reply to this message, I'm not sure if it's because of the long lines or not.
TIA
>
>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?