DAO, Oracle, rst.Update - "VB6.exe has generated Errors"
Posted on 2003-03-14
I have a program that works with SQL Server and am converting it to work with Oracle.
While updating a recordset, my program totally crashes VB6!
I have a DAO recordset (Not my idea to use DAO),
Set .AddNew, and it some values, attempt .Update,
and I get "VB6.exe has generated errors and will be shut down by Windows"
I have error checking in the program but the problem is so severe that
VB6 IDE shuts down.
I am connecting to Oracle with a Trigger on the table, a sequence to
fill the primary key (called by the trigger).
I just got one - I am going to disable constraints on my table in Oracle
and see what happens.
But I am still listening...