Row cannot be located for updating saleslogix
I am in the process of converting a My SQL database application that uses this approach from VB6 to VB. I used VBMy SQLDirect in VB6 and have switched to just using My Sql Data Reader and action queries on the VB. This same app also needs to access SQL Server databases for some of its data.
For that I can use Sql Data Reader and action queries.
Some Valuesmay have been change since it was last read."Here is the code. I save them, and in a large order (25 or more) there will be at least one which causes an error "Row cannot be located for updating.Some values may have been changed since it was last read." The values looked up have not changed, the only change might be price or quantity.Some values may have been changed since it was last read'The error seems to only occur when I edit fields in a newly created record? I am using D6 and the following components: TADOConnection, ADOQuery, ADOTable, Datasource.I've already searched the this forum and the suggestions haven't fixed the issue. TC 71205Even before I touch anything the error occurs within this code.