RE: [U2] - Determining time sequence {Unclassified}

2005-06-30 Thread Ross Ferris
-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR >Sent: Friday, 1 July 2005 9:52 AM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] - Determining time sequence {Unclassified} > >Ross, > >> -Orig

RE: [U2] - Determining time sequence {Unclassified}

2005-06-30 Thread HENDERSON MIKE, MR
Ross, > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris > Sent: Friday, 1 July 2005 10:51 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] - Determining time sequence > > My only issue with using UUID

RE: [U2] - Determining time sequence

2005-06-30 Thread Bruce Nichol
rom: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] >Sent: Thursday, 30 June 2005 12:15 PM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] - Determining time sequence > >Ross, I'm not derogating the use of sequential IDs but IIRC, th

RE: [U2] - Determining time sequence

2005-06-30 Thread Ross Ferris
-users@listserver.u2ug.org >Subject: RE: [U2] - Determining time sequence > >Ross, I'm not derogating the use of sequential IDs but IIRC, the bloke had >a reason not to use a sequential id counter and wanted an alternative. >The uuid spec states that uuid should cater for ti

RE: [U2] - Determining time sequence

2005-06-29 Thread Stuart . Boydell
Ross, I'm not derogating the use of sequential IDs but IIRC, the bloke had a reason not to use a sequential id counter and wanted an alternative. The uuid spec states that uuid should cater for time adjustments on the local clock, hence, shouldn't be "vulnerable" (Of course, in the real world,

RE: [U2] - Determining time sequence

2005-06-29 Thread Stuart . Boydell
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] - Determining time sequence

2005-06-29 Thread Ross Ferris
ina Software Visage - an Evolution in Software Development >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] >Sent: Tuesday, 28 June 2005 7:14 PM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] - Determinin

RE: [U2] - Determining time sequence

2005-06-28 Thread Bob Gerrish
time order. Cheers, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Tuesday, 28 June 2005 11:45 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] - Determining time sequence Maybe you should (re)read the thread on sequential IDS

RE: [U2] - Determining time sequence

2005-06-28 Thread Stuart . Boydell
Given an uuid string generated by AIX uuid_gen: b6e7ce371f25.02.ac.1e.10.03.00.00.00 Under Windows "uuidgen.exe -x": 9b0a5933-e7b1-11d9-868e-000bcdf8b9a5 The first part(s) of these are time based, though it may be difficult (but not impossible) to convert it back into a UV date/time format, the

RE: [U2] - Determining time sequence

2005-06-28 Thread Ross Ferris
OTECTED] >Sent: Tuesday, 28 June 2005 12:04 PM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] - Determining time sequence > >Another possability is to implement the UUID generator for your OS. It's >gauranteed to be unique and you can also implement this scheme across >mac

RE: [U2] - Determining time sequence

2005-06-27 Thread Stuart . Boydell
One thing I forgot to mention about using system(99) is that, if for any reason, the machines clock is adjusted backwards (eg. ntd), there is an increased probability of duplicate numbers arising. With uuid, this should be handled by the uuid implimentation. Regards, Stuart Boydell [EMAIL PROT

RE: [U2] - Determining time sequence

2005-06-27 Thread Timothy Snyder
[EMAIL PROTECTED] wrote on 06/27/2005 09:32:35 PM: > If you are on UNIX you can simply set TZ to different values > before running a > program which records SYSTEM(99). To expand on this, you could switch to a time zone that doesn't observe Daylight Saving Time before running the program. Tim

RE: [U2] - Determining time sequence

2005-06-27 Thread Stuart . Boydell
Another possability is to implement the UUID generator for your OS. It's gauranteed to be unique and you can also implement this scheme across machines. eg. aix: sh -c "/.../uuid_gen" linux: uuidgen win: uuidgen.exe (win sdk command line tool) or CreateObject("Scriptlet.TypeLib").Guid,38 (Win S

RE: [U2] - Determining time sequence {Unclassified}

2005-06-27 Thread HENDERSON MIKE, MR
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] > Sent: Tuesday, 28 June 2005 12:42 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] - Determining time sequence [snip] > > This would give you ~1

RE: [U2] - Determining time sequence

2005-06-27 Thread Bruce Nichol
Goo'day, At 10:42 28/06/05 +1000, you wrote: And how many milliseconds are you allowing in each second Mike? 1000/18 ~= 55 I knew Wellington had its charms, but time going past 10 times more quickly wasn't one that sprang to my mind first ;^) So *that's* why they all look so old and wrink

RE: [U2] - Determining time sequence

2005-06-27 Thread [EMAIL PROTECTED]
Phil Walker wrote: > My only doubt is having not used this before, is making sure that the > number is indeed sequential and does not get adjusted with DST. Agreed > it shouldn't but I am not sure how I would test this apart > from waiting until DST to start/finish. If you are on UNIX you can sim

RE: [U2] - Determining time sequence

2005-06-27 Thread [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote: > What doubts, Phil? > > Seems, at a very quick glance, to work OK on UV10.0.15/Win2K3 > > If you could have more than one transaction per second, you could code > > GMTSecs = SYSTEM(99) > MilliTime = TIME() > TimeStamp = GMTSecs + MilliTime - INT(MilliTime) > > This wo

RE: [U2] - Determining time sequence {Unclassified}

2005-06-27 Thread phil walker
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Tuesday, 28 June 2005 12:16 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] - Determining time sequence {Unclassified} What doubts, Phil? Seems, at a very quick glance, to work OK on UV10.0.15/Win2K3 If you could have

RE: [U2] - Determining time sequence

2005-06-27 Thread phil walker
Ferris Sent: Tuesday, 28 June 2005 11:45 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] - Determining time sequence Maybe you should (re)read the thread on sequential IDS --> simply have a "counter" that you increment and you can then be sure to maintain the correct sequence of e

RE: [U2] - Determining time sequence {Unclassified}

2005-06-27 Thread HENDERSON MIKE, MR
ECTED] On Behalf Of phil walker > Sent: Tuesday, 28 June 2005 10:38 > 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 kn

RE: [U2] - Determining time sequence

2005-06-27 Thread Ross Ferris
005 8:38 AM >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 o

RE: [U2] - Determining time sequence

2005-06-27 Thread Kevin King
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

[U2] - Determining time sequence

2005-06-27 Thread phil walker
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) fu