So I am one step further (who read my last thread: The problem was due to a change from FireDac to IBX in the source row order)
The query below looks complex, but the question is not.
The query shall return the NEW primary key which is generated by a generator.
This has worked before in Firedac, so it shall be an easy change for those who know the trick in IBX.
so here is the query of which only the last line shall be important
(zukonto
, STATUS_
,POSITION_
,FK_KONTRAKT
,NAME_
,COMM
,ERGEBNIS
,ENTRY_PRICE
,ENTRY_DATE
,EXIT_DATE
,ENTRY_TIME
,EXIT_TIME
,STOP
,WORST
,TARGET
,BEST
,PL
,MARGIN
) values (:zuKonto
,:STATUS_
,:POSITION_
,:FK_KONTRAKT
,:NAME_
,:COMM
,:ERGEBNIS
,:ENTRY_PRICE
,:ENTRY_DATE
,:EXIT_DATE
,:ENTRY_TIME
,:EXIT_TIME
,:STOP
,:WORST
,:TARGET
,:BEST
,:PL
,:MARGIN
) returning id_trade;'
The error message reads
Field not found : "id_trade"
The fields shall be returned and does not exist when I submit the query.
How to solve? I remember, that I tried for a long time to do it by Delphi / Firedac.
This putting above had worked there.
Can anybody give me the hint, how to return the newly generated primary key with IBX?
Thanks.