Myles asked:
> 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?
In my experience, using the BDE forces you into the 2-step
process. IBObjects implements an approach which makes it
possible to do in one step (though I've not used it myself).
cheers,
peter
============================================
Peter Hyde, SPIS Ltd, Christchurch, New Zealand
* Print-to-Web automation http://TurboPress.com
* Web design, automation and hosting specialists
* TurboNote: http://TurboPress.com/tbnote.htm
-- small, FREE and very handy
Find all the above and MORE at http://www.spis.co.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
