Getting primary key generated by trigger.

Alan

Delphi Developer

Thu, 18 Sep 2003 15:34:32 GMT

Getting primary key generated by trigger.

Hi,
Can anyone tell or point my in the right direction on how i would obtain
the primary key field that is generated when i insert another record. I
need to know the one it creates so that i can link another table to it using
this.

Thanks for any pointers.

Daniel Tyten

Delphi Developer

Thu, 18 Sep 2003 16:53:33 GMT

Re:Getting primary key generated by trigger.

Use the GeneratorField property of your TIBQuery or TIBDataSet component to
fill in the new generator value into your key field, after inserting a new
record in your masterdataset you just have to read it (MyKeyField.Value).
You have to set Apply Event to 'On New Record' (default) when configuring
the GeneratorField property of course.

Quote

Alan wrote in message <3ac6dc28$1_2@dnews>...
>Hi,
> Can anyone tell or point my in the right direction on how i would
obtain
>the primary key field that is generated when i insert another record. I
>need to know the one it creates so that i can link another table to it
using
>this.

>Thanks for any pointers.

Other Threads

1. Getting generated primary key

2. Primary key or not primary key.........

3. Primary-key generated befor posting inserts - where ??

4. auto generate a primary key value

5. Cached updates and generated primary key

6. Best practice on how to generate primary keys in a multi user system

7. Generate ID vs. Primary key from data

8. Value of primary Key generated by a generator

9. Generating Unique Primary Keys

10. Oracle, D6, Triggers, Sequences and Primary Keys