MySQL Bugs: #585: Runtime Error

Bug #585	Runtime Error - UPDATING a row
Submitted:	4 Jun 2003 8:31	Modified:	6 Jul 2003 13:30
Reporter:	Durahman Hamdan	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.0.12	OS:	Windows (Windows 2000)
Assigned to:		CPU Architecture:	Any

Description:
I am using VB6.

I tried to UPDATE a row with the following VB click event:

Private Sub btnSave_Click()
    On Error GoTo UpdateFail
    ConnPetbas.BeginTrans
    RsMember.Fields("MemberName") = txtName.Text
    RsMember.Fields("MemberGender") = txtGender.Text
    [.... rest of VB statements.....]
    RsMember.Update
    ConnPetbas.CommitTrans
    MsgBox "RECORD UPDATED", vbInformation
    Exit Sub
UpdateFail:
    MsgBox "UPDATE FAIL!", vbExclamation
End Sub

When I run the program when I click the button tsavehe following message popup

Runtime Error 2147467259(80004005)
Query Based Update failed because the row to update couldnot be found

How to repeat:
Find the row to update.

If found change the required field and click save button.

Unfortunately the information you have provided is not enough to test
the problem.
If you are able for to create a small VB project together with the
dump of the table files, I would appreciate if you upload them into a
zip file at:

ftp://support.mysql.com/pub/mysql/secret

and let us know the file name.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".