Hello
In FB 2.5 I am using insert into MyTable (col1, col2) values(val1, val2) returning Id where Id is autoinc column (sequence generator + before insert trigger). How do I do it in FB 3.0? It doesn't like "returning Id". It displays this error: SQLDA error. Wrong number of parameters (expected 1, got 0) I have Id defined as IDENTITY. Can I get INDENTITY for the last inserted row without using SELECT GEN_ID(generator-name, 0) AS ID FROM RDB$DATABASE ? I am trying this with Firebird Maestro 15.11.0.1 (supports FB 3) on Win Server 2012 R2. With FB 2.5 all works as expected. Thank you. Zoran