By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,197 Members | 977 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,197 IT Pros & Developers. It's quick & easy.

OraOLEDB and Inner Join

P: n/a
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
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.