Lazarus 1.8 RC4, Zeos 7.2 RC1 and firebird 3.
table with PK generated by genereator.
Imagine I am adding records to a simple grid based table editor.
10+ years ago, with delphi and interbase I had to query the generator separately and fill in the primary key by code before inserting, or use a server side trigger to fill in the primary key for me, but the client application will lose track of the new record because the app doesn't know the value for the primary key. Now that firebird 2 can return the new primary key by the "returning" clause, is there any way to have the query component read back the primary key from returning clause?
I see people are talking about setting the AutoGenerateValue property in the field object to arAutoInc, but I don't even see the text in zeos nor fcl-db, seems the discuss is pretty outdated.