Article View: borland.public.cppbuilder.database.multi-tier
Article #1310Re: DB "KEY" problems ... Multi-tier
From: L Rotger
Date: Fri, 04 Feb 2000 00:00
Date: Fri, 04 Feb 2000 00:00
23 lines
1225 bytes
1225 bytes
Hi,
Having looked at the code on that page, I wonder if it implicitly locks
the row so no other processes can access it while you store the id, add one
and store it back on the table. I always send passthrough SQL to the server.
I don't know if this code would be enough.
Lucy
Mark Cashman (TeamB BCB) escribi๏ฟฝ en mensaje
<388E771E.394138F6@ix.netcom.com>...
>Hi, Tom!
>
>In almost every case it is far better to avoid use of autoincrement and
>generate your keys from a table in the database.
>
>Have a look at
>
>
>http://www.temporaldoorway.com/programming/cbuilder/databaseandbde/generate
uniqueid.htm
>
>for details on how to accomplish this.
Technical Details
Message-ID:
<87et0m$5in7@bornews.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<86k9ji$ohe8@bornews.borland.com> <388E771E.394138F6@ix.netcom.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: fcd2b,a87640cbe8ed192f X-Google-Attributes: gidfcd2b,public From: "L Rotger" <aircomp@bitel.es> Subject: Re: DB "KEY" problems ... Multi-tier Date: 2000/02/04 Message-ID: <87et0m$5in7@bornews.borland.com> X-Deja-AN: 581560317 References: <86k9ji$ohe8@bornews.borland.com> <388E771E.394138F6@ix.netcom.com> Organization: Another Netscape Collabra Server User X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700 Newsgroups: borland.public.cppbuilder.database.multi-tier