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["Update Resync"]->Value =
(long)ADODB::adResyncAll;
prs->Open(_bstr_t("SELECT * FROM TestTable WHERE 1=0"),
(IDispatch *)m_pConnection, ADODB::adOpenKeyset, ADODB::adLockOptimistic,
ADODB::adCmdText);
prs->AddNew();
prs->Fields->Item["Name"]->Value = "Some Text";
prs->Update();
long id = (long)prs->Fields->Item["ID"]->Value;
// throws an DB_E_DELETEDROW
prs->Close();
prs = NULL;
Is there a way to use INSERT RETURNING in ADO?
Michael von Boetticher
-----Ursprüngliche Nachricht-----
Von: Dimitry Sibiryakov [mailto:s...@ibphoenix.com]
Gesendet: Montag, 14. Mai 2018 12:48
An: firebird-odbc-devel@lists.sourceforge.net
Betreff: Re: [Firebird-odbc-devel] reading the just generated identity
throws an exception
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.
----------------------------------------------------------------------------
--
Check out the vibrant tech community on one of the world's most engaging
tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
