Clarification on AutoInc fields

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

Article #5179

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

#5179

From: Umberto Uderzo
Date: Thu, 28 Jun 2001 15:54

12 lines
1348 bytes

Hello all,

A question to clarify to myself the situation:
Does exists a provider-independent, robust (multi-user) way to track the
auto-incremented counter assigned as primary key by the DBMS to the records
inserted via ADO? I tried this in so much variants (under Interbase), and
never found a solution...
Just to know, if it's not possible i'll drop the autoInc field and use the
good-old method:
SELECT MAX(id)+1 FROM <table>

Thanks... Umberto Uderzo

Technical Details

Message-ID: <3b3b532b$1_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,2eab2f6830ef7732,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-06-28 09:14:48 PST
From: "Umberto Uderzo" <umberto@uderzo.it>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Clarification on AutoInc fields
Date: Thu, 28 Jun 2001 17:54:16 +0200
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 213.213.4.159
Message-ID: <3b3b532b$1_2@dnews>
X-Trace: dnews 993743659 213.213.4.159 (28 Jun 2001 08:54:19 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews