What was the question?
If I remember correctly it was about the best way to allocate sequential
numbers for record ID's? Yes?
Well here goes
Start trasnactions
Readu control record then
record.ID = control record
write record
control record += 1
write control record
end
end transaction
This seems to work for us. We do have loads of control records for generating
ID and we never have any missing numbers. We have an internal audit department
that goes around checking these things. Just had a quick check and there are
3140 users logged on to one of our systems and we don't have locking problems.
Nice, neat and simple.
If anything does go wrong then it is due to a major system problem, but we
don't have them anymore!!!
Les
-----Original Message-----
From: Bruce Nichol [mailto:[EMAIL PROTECTED]
Sent: 14 June 2005 05:04
To: [email protected]
Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION
START & COMMIT/RO...
Goo'day, Bob,
At 19:44 13/06/05 -0700, you wrote:
>Come on, people. A request was made for options.
I guess I'm one of those to whom you are referring. Please accept my
abject apologies.
However, in my defence, and in defence of those others, I'll add that the
discourse started with "options" and then evolved in to "SOX" and
auditors. Your offering came after that, so my (and, I assume, others)
response was geared towards the "latest level" of the discussion.....
> <snip>
>
>Now if you have something better, offer it up! The original poster
>wants options, so lend a hand instead of a finger.
>
>BobW
>
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:owner-u2-
> > [EMAIL PROTECTED] On Behalf Of Steve Johnson
> > Sent: Monday, June 13, 2005 4:29 PM
> > To: U2UG
> > Subject: Re: [U2] Best practice for Sequential IDs using TRANSACTION
>START
> > & COMMIT/RO...
> >
> > But this would not keep those pesky auditors happy. In the following
> > sequence,
> > how could they know that item 1*4 was missing?
> >
> > 1*1
> > 1*2
> > 1*3
> > 2*1
> > etc.
> >
> > Regards,
> > Steve Johnson
> > FXA Group Ltd
> > Bangkok
> >
>[snip]
>-------
>u2-users mailing list
>[email protected]
>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.7.0 - Release Date: 13/06/05
>
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.323 / Virus Database: 267.7.0 - Release Date: 13/06/05
Regards,
Bruce Nichol
Talon Computer Services
ALBURY NSW 2640
Australia
http://www.taloncs.com.au
Tel: +61 (0)411149636
Fax: +61 (0)260232119
If it ain't broke, fix it till it is!
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.7.0 - Release Date: 13/06/05
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
This message has been comprehensively scanned for viruses,
please visit http://virus.e2e-filter.com/ for details.
This e-mail and any attachments are confidential and intended solely for the
use of the addressee only. If you have received this message in error, you must
not copy, distribute or disclose the contents; please notify the sender
immediately and delete the message.
This message is attributed to the sender and may not necessarily reflect the
view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements
binding Travis Perkins may not be concluded by means of e-mail communication.
E-mail transmissions are not secure and Travis Perkins accepts no
responsibility for changes made to this message after it was sent. Whilst steps
have been taken to ensure that this message is virus free, Travis Perkins
accepts no liability for infection and recommends that you scan this e-mail and
any attachments.
Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way,
Harlestone Road, Northampton, NN5 7UG.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
