Hi,
I work on a VB6 software using ADO to connect to Oracle 9.2i.
When I create a recordset based on a query containing a "inner join" clause
(sql server syntax, the software connects also to sql server and the "inner
join" syntax must be preserved for a large fraction of the queries), AddNew
and Update methods fail.
Initially, I was using the MSDAORA provider ... With this provider, the
BASETABLENAME property of each fields of the recordset is wrong. All fields
are considered as belonging to the same table and the recordset is thus not
updatable.
So I have changed the provider to OraOLEDB.Oracle ... With this provider the
BASETABLENAME is correct, each field is associated with its origin table BUT
the Update and AddNew still fail :(
Any solution ?
Is it definitively impossible to update "inner join" recordsets ?
Thank you for your help,
Richard
I work on a VB6 software using ADO to connect to Oracle 9.2i.
When I create a recordset based on a query containing a "inner join" clause
(sql server syntax, the software connects also to sql server and the "inner
join" syntax must be preserved for a large fraction of the queries), AddNew
and Update methods fail.
Initially, I was using the MSDAORA provider ... With this provider, the
BASETABLENAME property of each fields of the recordset is wrong. All fields
are considered as belonging to the same table and the recordset is thus not
updatable.
So I have changed the provider to OraOLEDB.Oracle ... With this provider the
BASETABLENAME is correct, each field is associated with its origin table BUT
the Update and AddNew still fail :(
Any solution ?
Is it definitively impossible to update "inner join" recordsets ?
Thank you for your help,
Richard