Subject | Re: [firebird-support] FB 3.0, how to get IDENTITY of last inserted row |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2016-04-27T19:20:44Z |
27.04.2016 21:04, 'Zoran' zoran565@... [firebird-support] wrote:
returned Id.
For me everything work with isql:
WBR, SD.
> It doesn’t like “returning Id”. It displays this error: SQLDA error. Wrong number ofThis is an application bug. Obviously, the application hasn't prepared place for
> parameters (expected 1, got 0)
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.