Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    1

    Unhappy Unanswered: help me, "unable to locate the row for update" error

    I'm use MySql with VisualBasic and ADO (MDAC 2.6 SP2) and MyODBC 2.50.39.

    When I try update a row, the error "unable to locate the row for update..." appear.

    Somebody can help me.

    Thanks

    Enrique

  2. #2
    Join Date
    Jul 2002
    Posts
    55
    In what situation does this arise (can you post an example of the SQL you're executing)? Also, can you post the complete error message?

  3. #3
    Join Date
    Apr 2003
    Location
    china
    Posts
    1

    here is some reasons

    1.you retrieve some fields from database but not include the primary key ,then you modify it and update ,this error happens,the answer is to include the primary key .
    2. you open a query, then the data is changed somewhere else ,so the opened query can not find the modified data , error happens the answer is to requery before any locate opeartions

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •