Click to See Complete Forum and Search --> : ResultSet Problem


August 13th, 1999, 02:10 AM
I am new to VB and working in a VB5/Oracle8
project.When I want to insert an record useing result
set (addnew) and if first time user gives the duplicate
key.Oracle gives the error and next time user changes
it and try to insert it gives the error "INVALID RESULTSET
STATE FOR UPDATE"
Please help me..
Thanx in advance
RK

S joy
August 13th, 1999, 09:27 AM
If your some for control loop for insertion, then Use ADDNEW method
before inserting into the fields of the recordset Or try to use ADO 2.0 or 2.1