Hi guys,
i use a SQLQuery in a project to connect to a Firebird database. In my table i use a BEFORE INSERT trigger for my primary ID field. In the same transaction i have to insert a detail row in another column. How can i find out the ID result after post but before commit?

ps : i tried ZEOSDB and generators worked like a charm, but using ZEOSDB made my app sluggish -------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20140327/c5b4aad1/attachment.html>

There is currently no way to do this unless you run a second query that uses a unique field to retrieve the ID.

if you are using a manual insert query you can do
INSERT INTO YOURTABLE (fields) VALUES (yourvalues) RETURNING ID and use a OPEN to retrieve the ID.

ps : i tried ZEOSDB and generators worked like a charm, but using ZEOSDB made my app sluggish

There are some plans to support such a thing but nothing was implemented yet.

Michael.

There is currently no way to do this unless you run a second query that uses a unique field to retrieve the ID.

if you are using a manual insert query you can do
INSERT INTO YOURTABLE (fields) VALUES (yourvalues) RETURNING ID and use a OPEN to retrieve the ID.

ps : i tried ZEOSDB and generators worked like a charm, but using ZEOSDB made my app sluggish

There are some plans to support such a thing but nothing was implemented yet.

Michael.

There is a DBGrid linked to that Query so i can't :( also i tried to use returning inside the InsertSql statement and it didn't word (i thought maybe it will update the ID field)

Done!
I used the second query method on the beforepost event and it works fine

I would like to try expanding the TSQLQuery to be able to use generator fields, can someone help me send the patch after?

Thank you Michael for your help

-----?????? ??????-----