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[
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.
---
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