1. Single Step - include generator in your Insert value list.
but you never know what the Generator value was.
2. You need to know the PK for some other reason eg to populate a child
object. No way around using 2 step process here. ie you have to select back
the Generator Value first. However, IB is real fast at this.
3. Do it in your before Insert trigger.
Same problem as (1)
4. Do it in a stored proc.
No one method is the perfect solution. They all have their place.
There is no other special single step way to do it.
At least their isn't a BDE in the middle, and using FIB to do this is about
the thinest solution you can get.
Cheers,
Tony.
-----Original Message-----
From: Myles Penlington <[EMAIL PROTECTED]>
To: Multiple recipients of list database <[EMAIL PROTECTED]>
Date: Tuesday, 21 September 1999 1:30 PM
Subject: [DUG-DB]: Interbase Generators & Insert statements.
>This must get asked several times ...
>
>If you are using an generator for a primary key (PK) in conjunction with an
>Insert Trigger, is there any way with FIB/IBX/TQuery to get back the
>generated PK
>value?
>
>Or do I have to use a Stored procedure to create an new PK value inside the
>same transaction and then use that in the SQL insert statement?
>
>Are there any other methods of doing this?
>
>I was just looking for a way to do this without doing 2 SQL statements back
>to the server (ie the SQL select for the stored procedure/generator and the
>SQL
>Insert).
>
>Thanks.
>
>Myles Penlington
>Software Engineer
>ADVANCED MANAGEMENT SYSTEMS
>
>---------------------------------------------------------------------------
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
