Updateable dynaset using Oracle OCX in Visual Basic

I am attempting to create an updateable dynaset in Visual Basic 4.0 using the new Oracle OCX. I am able to do this when my SQL statement is extremely simple. For example, the following statement returns an updateable dynaset : "Select CODIV, DEPT From ERRORS"

However, my recordset becomes non-updateable whenever I try to perform an outer join. Here is the SQL that is giving me trouble :

"Select a.CODIV, a.DEPT, b.NAME From ERRORS a, CAMPUS b Where a.CODE =
      b.CODE(+)"

The help file supplied by Oracle did not really help me. Here is all the information I could find addressing the issue :

"For the dynaset to be updatable, three conditions must be met:

1. The statement must refer to a simple column list or to the entire column list (*)
2. The statement must not set the read-only flag of the options argument
3. Oracle must permit ROWID references to the selected rows of the query."

I have full permissions on the tables in Oracle (update, delete, and insert). I am not ready to accept that it is impossible to retrieve an updateable dynaset when using multiple tables (if it can't be done, then what is the point of using relational databases?).

Does anyone have any suggestions? I would much rather find out that I am doing something wrong than find out that this cannot be done at all.

Thank you for your time,

Kenny Zoodsma
kzoodsma_at_harris.com Received on Wed Mar 26 1997 - 00:00:00 CST