Re: [SQL] Obtaining the primary key of the record just inserted

It worked perfectly. Thanks a million, Scott. Best, Oliveiros - Original Message - From: "Scott Marlowe" <[EMAIL PROTECTED]> To: "Oliveiros Cristina" <[EMAIL PROTECTED]> Cc: Sent: Thursday, November 08, 2007 6:03 PM Subject: Re: [SQL] Obtaining th

Re: [SQL] Obtaining the primary key of the record just inserted

On Nov 8, 2007 11:56 AM, Oliveiros Cristina <[EMAIL PROTECTED]> wrote: > > Hello, All, > > I have the need to know the primary key assigned to a record I've just > INSERTed . > > Is there an easy way to solve this ? > > Similar to SQLServer's SELECT scope_identity() ; ? In 8.2 and up: insert int

[SQL] Obtaining the primary key of the record just inserted

Hello, All, I have the need to know the primary key assigned to a record I've just INSERTed . Is there an easy way to solve this ? Similar to SQLServer's SELECT scope_identity() ; ? Any help deeply appreciated Best, Oliveiros