Hi friends, I was searching in all forum but I can't find the answer to my question.
I have
SQLQuery1.SQL.Text := ' BEGIN; '
+' INSERT INTO MASTERDATA (THINGS) VALUES (THINGS) RETURNING ID; '
+' INSERT INTO DETAILDATA (IDMASTER,THINGS) VALUES (currval(''MASTERDATA _ID_seq''::regclass),THINGS); '
+' COMMIT; ';
I know that I have to use "SQLQuery1.Open" if I want to get the returning ID but I can't use a transaction SQL with Open.
My question is. How can I return values from transaction SQL using Open (or something like that)?.
Thanks.