Subject | Re: [IBO] Generator Links at runtime |
---|---|
Author | lester@lsces.co.uk |
Post date | 2002-07-06T07:25:35Z |
> the TIB_Query that runs this is created on the fly just before this...This looks OK
>
> SQL.TEXT := 'Select * from TABLE1';
> GeneratorLinks.Add('Table1_ID=gen_Table1_PK');
> Prepare;
> 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