Edit a multitable query Oracle 7.3

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