Re: Error message "Row cannot be located for updating"

Jonathan

It will be nice if you give the following details; so that it could to 
identify the reason for the error.

1. Table definition which caused the issue
    (show create table)

2. Code snippet of your vb code; so that it explains what kind of cursor 
and other options were used.

Thanks

Jonathan Trahair wrote:
> Hi Everyone
> 
> I am using VB6 and MySQL, recently installed. I have a FlexGrid of items. 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. I tried looking the order items up on their unique record number (primary key), then I tried on their order number, item name and colour (a unique set of values). It's always the same item(s) in a given order, but for different orders it will not be the same item, colour or row number as other orders.
> 
> I've been onto Google and found some stuff about Option=2 but that didn't make any difference.
> 
> Can anyone shed light on this dark area?
> 
> Thanks in advance.
> 
> Jonathan Trahair

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]