INSERT and get auto-value without extra sql!?

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

Article #2138

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

#2138

From: Markus Breuer
Date: Wed, 22 Oct 2003 17:01

9 lines
1350 bytes

I am using a table with an primary key of auto-value. The sql-INSERT 
forces an automatic value to be put into the column. Is there any way by 
using ado, to get this value without the need to use select?

I know oracle, for example, supports an dml returning clause. But ms 
access seems not support it. Also host variables are not supported.
Is there any api-function to get the value?

regards, markus

Technical Details

Message-ID: <bn6d5m$th6va$1@ID-164478.news.uni-berlin.de>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!uni-berlin.de!p508ec504.dip0.t-ipconnect.DE!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,5d631d0b61f4304c,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-10-22 10:01:43 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!uni-berlin.de!p508ec504.dip0.t-ipconnect.DE!not-for-mail
From: Markus Breuer <markus.breuer@gmx.de>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: INSERT and get auto-value without extra sql!?
Date: Wed, 22 Oct 2003 19:01:42 +0200
Lines: 10
Message-ID: <bn6d5m$th6va$1@ID-164478.news.uni-berlin.de>
NNTP-Posting-Host: p508ec504.dip0.t-ipconnect.de (80.142.197.4)
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de 1066842102 30972906 80.142.197.4 (16 [164478])
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de-DE; rv:1.4) Gecko/20030619 Netscape/7.1 (ax)
X-Accept-Language: de-de, de