mikeayuso
asked on
Row cannot be located for updating. Some values may have been changed since it was last read.
I'm using an adodc to access an informix table in my vb form. the recordsource for the adodc say something like this "select * from xtable order by userid, account"
Problem:
When i delete a record, or update a record I get the error. "Row cannot be located for updating. Some values may have been changed since it was last read." This occurs if the actual table has index primary keys "userid" and "account". However, I can add records with no problems.
Temporary workaround:
If i delee the primary keys in the table in informix, my application works well. I can update or delete records with no problems. NOTE I am using unique values and nonblank values for fields "userid" and "account" in all my records.
I need help with this. I need to keep my index keys in the table but to be able to update and delete records.
the commands I am using are for example:
"adoAccts.Recordset.Delete " to delete the current selected record
and
"adoAccts.Recordset.Update " to update the current selected record
Thanks,
Mike
Problem:
When i delete a record, or update a record I get the error. "Row cannot be located for updating. Some values may have been changed since it was last read." This occurs if the actual table has index primary keys "userid" and "account". However, I can add records with no problems.
Temporary workaround:
If i delee the primary keys in the table in informix, my application works well. I can update or delete records with no problems. NOTE I am using unique values and nonblank values for fields "userid" and "account" in all my records.
I need help with this. I need to keep my index keys in the table but to be able to update and delete records.
the commands I am using are for example:
"adoAccts.Recordset.Delete
and
"adoAccts.Recordset.Update
Thanks,
Mike
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.