Re: Last insert key

Article View: borland.public.interbase.sql

Article #11105

Back to borland.public.interbase.sql Previous Next

#11105

From: newsgroups.borland.com
Date: Thu, 12 Dec 2002 17:40

30 lines
2114 bytes

But how do i get the ID????
and then the trigger is only fired when i have an insert...
or do i have 2 use the generated key to insert that as a value in my insert
query????

what would the use be of the GEN_ID() and oninsert function???

tnx Rim

"Craig Stuntz [TeamB]" <cstuntz@nospamplease.com (but use vertexsoftware to
email)> schreef in bericht
news:MPG.18628e9dc84bf9dc98a3c1@newsgroups.borland.com...
> In article <3df8bc1a$1@newsgroups.borland.com>, rim@novicom.nl says...
> > does anybody know what the smartest way is to get your autonumbered
field
> >
> > i'm using D6 with interbase 6 and have a generated id using the trigger
in
> > interbase itself
> >
> Get the ID first, then insert the record.  Now you know the ID
> value.
>
> -Craig
>
> --
> Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
> Delphi/InterBase Weblog : http://delphi.weblogs.com
> InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
> InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Technical Details

Message-ID: <3df8ca1e$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3df8bc1a$1@newsgroups.borland.com> <MPG.18628e9dc84bf9dc98a3c1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 114a0e,1f84ba5a3b79c5df
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-12 10:08:18 PST
From: "newsgroups.borland.com" <rim@novicom.nl>
Newsgroups: borland.public.interbase.sql
References: <3df8bc1a$1@newsgroups.borland.com> <MPG.18628e9dc84bf9dc98a3c1@newsgroups.borland.com>
Subject: Re: Last insert key
Date: Thu, 12 Dec 2002 18:40:59 +0100
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 213.84.151.204
Message-ID: <3df8ca1e$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039714846 213.84.151.204 (12 Dec 2002 09:40:46 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message