MS Access, autonumber (autoincrement) and returning value

Article View: borland.public.cppbuilder.database.ado

Article #1577

Back to borland.public.cppbuilder.database.ado Previous Next

#1577

From: Claude
Date: Fri, 21 May 2004 18:08

8 lines
1159 bytes

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: <40ae45bf$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,823c765280cf08e6,start
X-Google-Attributes: gid10698b,public
Reply-To: "Claude" <claude@dev.scomage.com>
From: "Claude" <claude@dev.scomage.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: MS Access, autonumber (autoincrement) and returning value
Date: Fri, 21 May 2004 14:08:56 -0400
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 69.142.220.173
Message-ID: <40ae45bf$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1085162943 69.142.220.173 (21 May 2004 11:09:03 -0700)
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail