Article View: be.comp.programming
Article #4626Re: [VB6] id van laatste insert in database
From: KLinZ
Date: Thu, 17 Jul 2003 17:10
Date: Thu, 17 Jul 2003 17:10
14 lines
1799 bytes
1799 bytes
Billyke wrote: >> 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. > > In SQL Server kan je dit opvragen met @@IDENTITY > Weet wel niet of dit ook in Access werkt... In Access is het een functie, te weten: LAST_INSERT_ID(). -- www.zenobits.com
Technical Details
Message-ID:
<JLARa.18252$KF1.304080@amstwist00>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-05!sn-xit-09!supernews.com!216.170.153.135.MISMATCH!tdsnet-transit!newspeer.tds.net!news-out1.nntp.be!propagator2-sterling!news-in-sterling.newsfeed.com!npeer.de.kpn-eurorings.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!proxad.net!news-hub.cableinet.net!blueyonder!amsnews01.chello.com!amstwist00.POSTED!not-for-mailReferences:
<3f16c490$0$304$ba620e4c@reader1.news.skynet.be> <bf6hdr$o18$1@reader10.wxs.nl>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 10:10:07 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-05!sn-xit-09!supernews.com!216.170.153.135.MISMATCH!tdsnet-transit!newspeer.tds.net!news-out1.nntp.be!propagator2-sterling!news-in-sterling.newsfeed.com!npeer.de.kpn-eurorings.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!proxad.net!news-hub.cableinet.net!blueyonder!amsnews01.chello.com!amstwist00.POSTED!not-for-mail From: "KLinZ" <klinz@NOSPAMzenobitsSPAMNO.com> Newsgroups: be.comp.programming References: <3f16c490$0$304$ba620e4c@reader1.news.skynet.be> <bf6hdr$o18$1@reader10.wxs.nl> Subject: Re: [VB6] id van laatste insert in database Lines: 14 Organization: Inc. MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit 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 Message-ID: <JLARa.18252$KF1.304080@amstwist00> Date: Thu, 17 Jul 2003 19:10:57 +0200 NNTP-Posting-Host: 212.187.71.152 X-Complaints-To: abuse@chello.nl X-Trace: amstwist00 1058461801 212.187.71.152 (Thu, 17 Jul 2003 19:10:01 MET DST) NNTP-Posting-Date: Thu, 17 Jul 2003 19:10:01 MET DST