-2147217864 Row cannot be located for updating.

From: Vineet (Vineet_at_newsgroup.nospam)
Date: 12/27/04 

Date: Mon, 27 Dec 2004 10:11:01 -0800

I am using ADODB recordset and OLEDB to connect to ORACLE database from MS
PROJECT.
In one of my MS PROJECTS when I try to write to ORACLE database I get this
error
"-2147217864 Row cannot be located for updating. Some values may have been
changed since it was last read".

The interesting thing to note that error is thrown not at update command but
at recordset.AddNew command. And the error is generated after few iterations
are done.

Here is the code snippet .......

If rsSchedule.EOF Or rsSchedule.BOF Then 'No Records exists for selected
Project ID
    'Insert data in recordsets
    For rsRows = 0 To aryRows - 1
        
        rsSchedule.AddNew
        rsSchedule.Fields(0) = CInt(arydata(rsRows, 0))
        rsSchedule.Fields(1) = CInt(arydata(rsRows, 1))
        rsSchedule.Fields(2) = CStr(arydata(rsRows, 2))
        rsSchedule.Fields(3) = CInt(arydata(rsRows, 3))
        rsSchedule.Fields(4) = arydata(rsRows, 4)
        rsSchedule.Fields(5) = arydata(rsRows, 5)
        rsSchedule.Fields(6) = arydata(rsRows, 6)
        rsSchedule.Fields(7) = arydata(rsRows, 7)
        rsSchedule.Fields(8) = CInt(arydata(rsRows, 8))
        rsSchedule.Fields(9) = CStr(arydata(rsRows, 9))
        rsSchedule.Fields(10) = arydata(rsRows, 10)
        rsSchedule.Fields(11) = CStr(arydata(rsRows, 11))
    
    Next rsRows
    rsSchedule.Update
    rsSchedule.MoveLast
Else if .........

I will appreciate any help.

Thanks

Relevant Pages

  • ADO Recordset truncating memo field
    ... dates for weekends and holidays) from our corporate Oracle database so it can ... The recordset data is displayed in more unbound controls on the ... Dim rst As ADODB.Recordset, frm As Form ... Exit Sub ...
    (microsoft.public.access.modulesdaovba)
  • ODBC database access
    ... I would like to query the Oracle database using ODBC on an Excel ... it didn't recognise the Database and Recordset datatype. ... I also found that there were many other examples that used the ODBC ... I am using Excel 2002 with Visual Basic 6.0 as Visual Basic Editor. ...
    (microsoft.public.excel.programming)
  • Re: Visual Basic code for insert or update Database
    ... recordset using the connection to the Oracle database. ... > For Each objRegKey In objRootKey.SubKeys ...
    (microsoft.public.vb.database.ado)
  • A97 vs AXO (2002)
    ... 1)Try one or more queries straight on the Oracle database ... using SQL PLUS or alike ... >Next, open the recordset: ... >Set rst = qry.OpenRecordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: Understanding bizarre sp_cursorfetch performance
    ... I changed to OLEDB and found that it avoid using the cursors ... read/only recordset and just grab the data. ... Profiler is showing the first fetch ...
    (microsoft.public.sqlserver.programming)