Article View: borland.public.cppbuilder.database.ado
Article #1264Re: MS Access, autonumber (autoincrement) and returning value
From: Nigel
Date: Tue, 07 Sep 2004 15:07
Date: Tue, 07 Sep 2004 15:07
21 lines
1695 bytes
1695 bytes
As soon as the new record that has been inserted is posted you can read the value of the autonumber. This number can only be generated when the new record is posted, because another user might insert and post another record to the same table while you are still adding field information and therefore the first come first serve principle applies. Nigel "Claude" <claude@dev.scomage.com> wrote in message news:40ae45bf$1@newsgroups.borland.com... > How do I retrieve the value of an autonumber column > after it is inserted into a table? > > Select maxis bad because other records my be inserted > into the table from other occurances of the application > running at the same time. > > Could this be applied to Oracle and SQL Server? > >
Technical Details
Message-ID:
<413dcdd7@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<40ae45bf$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,823c765280cf08e6 X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Nigel" <nhussey@gltame.com> Newsgroups: borland.public.cppbuilder.database.ado References: <40ae45bf$1@newsgroups.borland.com> Subject: Re: MS Access, autonumber (autoincrement) and returning value Date: Tue, 7 Sep 2004 17:07:43 +0200 Lines: 23 Organization: Grinaker - LTA X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 NNTP-Posting-Host: 196.38.60.194 Message-ID: <413dcdd7@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1094569431 196.38.60.194 (7 Sep 2004 08:03:51 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail