Re: [VB6] id van laatste insert in database

Article View: be.comp.programming

Article #4625

Back to be.comp.programming Previous Next

#4625

From: Billyke
Date: Thu, 17 Jul 2003 16:03

33 lines
1977 bytes

"Robrecht Jacques" <Robrecht.Jacques@advalvas.be> wrote in message
news:3f16c490$0$304$ba620e4c@reader1.news.skynet.be...
> Hallo,
>
> hoe kan ik de ID van de laatste INSERT (SQL) in een database bekomen? Ik
> gebruik (enkel relevante code):
>
>   dim db as connection
>   dim sql as string
>
>   set db = new connection
>   db.open "DRIVER={Microsoft Access Driver (*.mdb)};" & _
>           "DBQ=c:/path/to/data.mdb;" & _
>           "Exclusive=1"
>   sql = "INSERT INTO Table (Field1, Field2) " & _
>         "VALUES ('Value1', 'Value2')"
>   db.execute sql
>   db.close
>   set db = nothing
>
> De tabel 'Table' heeft daarnaast nog een auto-increment field (als primary
> key): Id1. Nu zou ik graag de waarde van die Id1 hebben voor een volgende
> insert.
>
> Thx,
> Robrecht
>
>
>

In SQL Server kan je dit opvragen met @@IDENTITY
Weet wel niet of dit ook in Access werkt...

Technical Details

Message-ID: <bf6hdr$o18$1@reader10.wxs.nl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!diablo.theplanet.net!kibo.news.demon.net!demon!newshub1.home.nl!home.nl!amsnews01.chello.com!newsfeed.wxs.nl!textnews.wxs.nl!not-for-mail

References: <3f16c490$0$304$ba620e4c@reader1.news.skynet.be>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: fcea4,b4fd27c755461f8b
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2003-07-17 09:03:28 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!diablo.theplanet.net!kibo.news.demon.net!demon!newshub1.home.nl!home.nl!amsnews01.chello.com!newsfeed.wxs.nl!textnews.wxs.nl!not-for-mail
From: "Billyke" <gert.verstappen@gmx.net>
Newsgroups: be.comp.programming
Subject: Re: [VB6] id van laatste insert in database
Date: Thu, 17 Jul 2003 18:03:16 +0200
Organization: Planet Internet
Lines: 35
Message-ID: <bf6hdr$o18$1@reader10.wxs.nl>
References: <3f16c490$0$304$ba620e4c@reader1.news.skynet.be>
NNTP-Posting-Host: 81.11.182.252
X-Trace: reader10.wxs.nl 1058457851 24616 81.11.182.252 (17 Jul 2003 16:04:11 GMT)
X-Complaints-To: abuse@planet.nl
NNTP-Posting-Date: 17 Jul 2003 16:04:11 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165

Reply to Parent Message