Why not put the time in the record and use a purely sequential key?
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of phil walker
Sent: Monday, June 27, 2005 4:38 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] - Determining time sequence
I need to generate a timebased sequential key which is independent of
daylight savings time, so that I can consistently know in what order
transactions took place even when they occur over the daylight saving
time changes.
I have found the following in the help system about the BASIC
SYSTEM(99)
function:
Returns the system time in the number of seconds
since midnight Greenwich Mean Time (GMT), January
1, 1970.
And initially thought I could use this function, but after some
testing are having doubts. Has anyone else done something similar to
this?
Cheers,
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.2/29 - Release Date:
6/27/2005
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.2/29 - Release Date:
6/27/2005
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
