What db are you using? If its interbase then you could write a stored
procedure or trigger that automaticlly inserts the date whenever a record is
written. Since this is all performed on the server then all transactions
from all clients would use the servers time.
I persume that you could do this kind of thing with other DB but interbase
is the only CS DB I have experience with.
Nahum
-----Original Message-----
From: Cheng Wei [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 8 February 2000 12:26
To: Multiple recipients of list delphi
Subject: [DUG]: Server time
Hi all,
I'm currently developing a time recording app to be used in the factory
environment, the DB resides in a central server with several workstations
connect to it. The workers record their activities via the workstations.
Some of the job items are budgeted and budgeted time can be as less as 5
minutes, therefore the accuracy of time records are significant.
Because the time settings are usually vary from wkstation to wkstation, so
if someone started a job item from one machine and then claim it from
another, the duration (the different between timestamp value) won't be
accurate.
I think the solution would be to use the server time for all. Could anyone
help me on how to get timestamp from server? or any other suggestions?
Thanks
Cheng
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
