Home -> Usenet -> comp.databases.oracle -> Oracle and Visual Basic

Oracle and Visual Basic

From: Gummi Johannesson <johanneg_at_quark.cs.rpi.edu>
Date: 28 Dec 1993 13:39:06 GMT
Message-ID: <2fpctq$538_at_usenet.rpi.edu> 






Hello everyone,



Recently, I started using Visual Basic and Microsoft`s ODBC to access a 
database on Oracle 7 server for Netware.  I cannot seem to be able to open 
an updatable dynaset although I can update the Oracle tables using the 
ExecuteSql method.


Here below is a Visual Basic code which opens the Oracle database and creates
one dynaset:

	Dim db as DataBase, d as DynaSet
	set db = OpenDatabase("", False, False, "ODBC;DSN=Oracle7;")
	set d = CreateDynaSet("select * from depcode")


When this code is finished "d" is a dynaset which is not updatable.
For example, d.updatable=False, and d.Edit cannot be executed.



Can anyone explain why this is the case ?  
I thought that the dynaset should be updatable just as if it were a dynaset
for the M.S. Access database.



I created an Access database and attached an Oracle table to it but the
dynaset for the oracle table was still non-updatable but dynasets for the
Access tables were updatable.



Can anyone explain to me what I am doing wrong here ?
Any comments would be greatly appreciated,



Thanks in advance,

	Gummi
	(johanneg_at_cs.rpi.edu)


Received on Tue Dec 28 1993 - 14:39:06 CET












Original text of this message