-2147217864 Row cannot be located for updating. Some values may have
been changed since it was last read.
Key column information is insufficient or incorrect. Too many rows
were affected by updated. -2147467259
i'm having trouble with this error for weeks. i've been delayed and i
simply don't know what's causing this error.
Do While RECSET2.EOF
recset!username = Ruser
recset!orseal = RECSET2!orseal
recset!ornum = RECSET2!ornum
recset!ordate = RECSET2!ordate
recset!oramt = (recset!oramt + RECSET2!Amt)
If RECSET2!applcode = pamc Then
recset!prn = RECSET2!Amt
ElseIf RECSET2!applcode = iamc Then
recset!Int = RECSET2!Amt
End If
recset.Update
RECSET2.MoveNext
Loop
so you see, i'm trying to update the record using .Update recordset
property. i have already assigned a primary key for the certain table
but there's still an error during edit only.
i've been using ado library 2.5 for recordset through odbc driver
accessing MySql control center. is it because of my data access
components or a bug in the odbc or mysql? what else could i do aside
from changing these line of codes to a SQL update statement? thanks
in advance.
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
