VB and oracle 7.1 
Author Message
 VB and oracle 7.1

I am having trouble doing updates to records in an Oracle 7.1 database table.  
I use CreateDynaset to see if I have matching records.  If there are no
matching records I can use MyDb.execute <sql statement> to insert records but
I am at a loss on how to get updates to work.  If I use MyDB.Execute with the
update sql statement I get a "operation must be an updatable query" (something
like that, err=3073).  If I use MyDB.EXECUTESQL(<sql>) my machine hangs.   I
have taken the sql statement and run it in SQLPlus (oracle's tool) and the SQL
works fine.

Environment is PC running win 3.11, VB 3, Oracle 7.1 running on an HP9000


Sun, 05 Apr 1998 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. VB to Oracle 7.1

2. GPF : VB 3.0 / MS-Jet 2.5 / ODBC 2.11 / Oracle 7.1

3. VB 3.0 and Oracle 7.1


5. Copying Oracle 7.1 long fields

6. VB4 and Oracle 7.1 Problems

7. Evil VBDB300.DLL Crash VB3>Oracle 7.1

8. ODBC Connect to ORacle 7.1 with VB4.0 (32bit)

9. Year2K Compliance of Microsoft Basic PDS 7.1 and Consulting Firms specializing in Y2K and PDS 7.1

10. QB 7.1 (sorry - PDS 7.1)

11. QB 4.5/Basic 7.1/VB 3/4/5 Consultants Available

12. QB 4.5/Basic 7.1/VB 3/4/5 Consultants Available


Powered by phpBB® Forum Software