VB5 / Oracle 803, Microsoft driver for Oracle 2.73 
Author Message
 VB5 / Oracle 803, Microsoft driver for Oracle 2.73

I am using RDO to access data in the Oracle server.

I have this error message "MSrdo resultset Error xxxxx,  bookmark",  l
when I click on the command buttion to add a new record.  Can some one
please point out my errors...  Thank you.

My code are as follows;
____________________

Private Sub cmdAddNew_Click()
Dim iResponse As Integer

   If mDirty Then
      iResponse = MsgBox("Dirty data. " _
         & "Save before adding a new record?", _
         vbYesNo + vbExclamation, "Dirty Data")
      If iResponse = vbYes Then
         DataSave
      End If
   End If

  ' On Error GoTo AddNewError
   mrdoRS.AddNew
   mrdoRS.Update
   mrdoRS.Move 0, mrdoRS.LastModified                  <- Error

   DataLoad

   Exit Sub

AddNewError:
   frmRDOErrors.ErrorColl = rdoErrors

End Sub



Wed, 06 Dec 2000 03:00:00 GMT  
 VB5 / Oracle 803, Microsoft driver for Oracle 2.73

The default resultset type for Oracle is forward only.  Therefore the move
method for anything but forward will get you an error.  Try using a different
type of result set such as a keyset which is scrollable.



Thu, 07 Dec 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Microsoft ODBC for Oracle 2.73: Where to get?

2. Oracle ODBC driver / Microsoft ODBC driver for Oracle

3. HELP on connection to Oracle with Microsoft ODBC for Oracle Driver

4. Trouble with ADO in VB5 to Oracle 7.33, using the Oracle 73 driver

5. Trouble with ADO in VB5 with Oracle 7.33 and Oracle 73 driver

6. Where can I get version 2.73 of ODBC Driver for ORACLE ??

7. How to increase the buffer size of Microsoft ODBC driver for Oracle

8. Driver of Microsoft for ORACLE

9. Oracle 8.1.5 and Microsoft ODBC Driver

10. Microsoft ODBC driver for Oracle, version2.0

11. Microsoft Oracle Driver and Nested queries

12. Microsoft Oracle ODBC driver and ADO

 

 
Powered by phpBB® Forum Software