Subject Re: [IBO] Generator Links at runtime
Author lester@lsces.co.uk
> the TIB_Query that runs this is created on the fly just before this...
>
> SQL.TEXT := 'Select * from TABLE1';
> GeneratorLinks.Add('Table1_ID=gen_Table1_PK');
> Prepare;

This looks OK

> TABLE1ID := GeneratorValue('gen_Table1_PK',1);

This simply does not work. GeneratorValue is a function in
SQL not Delphi.

GeneratorLinks automatically updates the Table1_ID value in
the database. If you need to look at the value after using
insert, then TIB_Query.FieldByName('Table1_ID').AsInteger
should give it. If you put it a OnDataChange event, then I
think you can assign that to TABLE1ID for convenience.

C is my native language so the Pascal may not be quite right
<g>

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services