Re: [firebird-support] FB 3.0, how to get IDENTITY of last inserted row

2016-04-27 Thread zoran...@yahoo.com [firebird-support]
Looks like Firebird Maestro has a bug. I've tried the same with Database Workbench 5 and all works as expected. Thank you guys... Zoran

Re: [firebird-support] FB 3.0, how to get IDENTITY of last inserted row

2016-04-27 Thread zoran...@yahoo.com [firebird-support]
You are right. I've tried the same with Database Workbench 5 and it works ok. Thank you, Dimitry :)

Re: [firebird-support] FB 3.0, how to get IDENTITY of last inserted row

2016-04-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.04.2016 21:04, 'Zoran' zoran...@gmail.com [firebird-support] wrote: > It doesn’t like “returning Id”. It displays this error: SQLDA error. Wrong > number of > parameters (expected 1, got 0) This is an application bug. Obviously, the application hasn't prepared place for returned Id.

Re: [firebird-support] FB 3.0, how to get IDENTITY of last inserted row

2016-04-27 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Hello Zoran, > > 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

[firebird-support] FB 3.0, how to get IDENTITY of last inserted row

2016-04-27 Thread 'Zoran' zoran...@gmail.com [firebird-support]
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