Subject Re: [firebird-support] FB 3.0, how to get IDENTITY of last inserted row
Author Dimitry Sibiryakov
27.04.2016 21:04, 'Zoran' zoran565@... [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.

For me everything work with isql:

> SQL> create table aaa(id integer generated by default as identity, col1 integer, col2 varchar(10));
> SQL> insert into aaa (col1, col2) values (1,'abc') returning id;
>
> ID
> ============
> 1
>
> SQL> show version;
> ISQL Version: WI-T4.0.0.86-dev Firebird 4.0 Unstable
> Server version:
> Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.86-dev Firebird 4.0 Unstable"
> on disk structure version 12.0


--
WBR, SD.