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
