Re: [Firebird-odbc-devel] reading the just generated identity throws an exception

2018-05-14 Thread Michael von Boetticher
Our problem is that we use ADO in our hole application. We have many places like this in our code: ADODB::_RecordsetPtr prs = NULL; CREATEINSTANCE(prs, ADODB::Recordset); prs->CursorLocation = ADODB::adUseClient; prs->Properties->Item[

Re: [Firebird-odbc-devel] reading the just generated identity throws an exception

2018-05-14 Thread Dimitry Sibiryakov
14.05.2018 12:46, Michael von Boetticher wrote: I need to know the generated ID for further actions in other subtables. Has somebody the same issue and even better - a solution for this? Use INSERT RETURNING. -- WBR, SD. ---

[Firebird-odbc-devel] reading the just generated identity throws an exception

2018-05-14 Thread Michael von Boetticher
Version: 3.0.3 32Bit ODB driver: 2.0.5 32 Bit I'm migrating a C++ App from MS-Access to Firebird 3.0. With MS-Access I used the identity column as primary key for table joining. Firebird gives the possibility to create a similar table with: CREATE TABLE TestTable (ID INTEGER GENERATED BY DEF