> 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?
What's the server... You could certainly write a stored procedure for ORACLE
to retrieve server time as I expect is possible for any other server DB... if your
DB is not a Server-based system then you will need a net API to retrieve the
server time...
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
