469,602 Members | 2,087 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

OraOLEDB and Inner Join

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
0 2462

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Ike | last post: by
3 posts views Thread by Prem | last post: by
3 posts views Thread by Zeff | last post: by
reply views Thread by Richard | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.