| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Edit a multitable query Oracle 7.3
It makes sense to me that a multi-table query against Oracle would return a read-only recordset. The same would be true of a query against a view where the view joined two or more tables.
If upgrading to Oracle8 is an option, you might be able to take advantage of the new "instead of" triggers, which allow you to write PL/SQL code to handle updates of views which join tables.
regards,
Jonathan Gennick
On Tue, 16 Sep 1997 18:37:06 -0600, cgan_at_direct.ca wrote:
>
>Hi,
>
>I have worked with PC databases for quite sometime and have always been
>able to edit in a multitable query.
>
>Can I do this with Oracle 7.3?
>
>I tried it on MS Query and it disallowed Edit on Multi-Table queries.
>I repeated the test with a similar query on SQL-Server 6.5 and got the
>same message.
>
>However, when I attach the tables to SQL-Server from MS Access and create
>the queries, I can edit it.
>
>But when I attach the tables to Oracle from MS Access and create
>the queries, the recordsets are read-only.
>
>Back to the original question. Can I edit a multi-table query in Oracle
>7.3?
>
>I am working on an application using VB 5.0 as the front end and Oracle
>as the back end server. I have got the following drivers installed:
>
> Name=Oracle73
> Version=2.00.0301
> File=sqo32_73.dll
> Date=Feb 4, 97
>
> Name=MS ODBC Driver for Oracle
> Version=2.00.006325
> File=MSORCL10.dll
> Date=Jan 12, 97
>
>Incidentally, I have tried both drivers and got the same result.
>
>Another thing I found with MS Query (or VB) to Oracle 7.3 using the
>Oracle73 driver, I cannot specify filter on any numeric field. However,
>with MS ODBC driver the problem disappear.
>
>Thanks
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
 |
 |