Results 1 to 3 of 3

Thread: meaning of the error message

  1. #1

    Thread Starter
    Member
    Join Date
    Jan 2000
    Location
    brooklyn
    Posts
    48
    what does the following message mean and how to sovle the
    problem?
    “the specified row could not be located for updating, some values
    may have been changed since it was last read”
    error number is -2147217864

    I used the ado data control to connect the sql server table
    in the vb. I used the adodc1.recordset.updatebatch to update the table. the cursorlocation is at the client site
    cursor type is static

    Please hellllllllp! Thanks a lot.

  2. #2
    Frenzied Member Buzby's Avatar
    Join Date
    Jan 1999
    Location
    UK
    Posts
    1,670
    I've never seen the specific message but it sounds like you've displayed a set of records from a database (like a grid for example) but by the time the user has gone to select a record it has been deleted or it has been changed in such a way it is not in the same place in the recordset as it was when you first displayed it.
    Or you may have opened a recordset to do some work on it, and by the time you've gone to update it it has been changed or deleted by someone else.
    'Buzby'
    Visual Basic Developer
    "I'm moving to Theory. Everything works there."

  3. #3
    Hyperactive Member
    Join Date
    Mar 2000
    Location
    India
    Posts
    298
    Im not sure if this will work, but maybe u can try changing the cursor type from static, coz once the recordset is opened as static any changes/deletion made by other users will not be visible to u.

    hope it helps.


Posting Permissions

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



Click Here to Expand Forum to Full Width