Updating a record

Hi
I hope someone can help. We've just taken over a site written in ASP. Unfortunately we specialise in PHP and we are struggling. On one particular function, two tables in the database are updated but I am getting the error below;

Microsoft Cursor Engine error '80040e38'

Row cannot be located for updating. Some values may have been changed since it was last read.

/database/database.asp, line 112


and the code that this is refering to is here;

recordSet.Update
Set tableFields = CreateObject("Scripting.Dictionary")

I can provide any information needed but I didnt want to bombard with irrelevent code.

Thank you in advance for any help.
Joe

 

check oracle related sites for updating and all !!!

 

You may need to set the 'CursorType' and 'LockType' when creating the recordset object:

                objRs = CreateObject("ADODB.Recordset")
                objRs.CursorType = 1
                objRs.LockType = 3

Code (markup):

It would also depend on what sql has been executed when you are trying to update the current record.