为何在使用ADO Recordset调用UpdateBatch的时候会出错?

[Michael1]

请问:
为什么我在使用ADO Recordset调用UpdateBatch的时候会出现以下错误.
Insufficient or incorrect key column information; too many rows
affected by update.
如果再运行,他又会提示出以下错误:
The specified row could not be located for updating:Somevalues may
have been changed since it was last read.

请问各位高人,如何解决.万分感谢.

[liyang]

你使用batchupdate,你的表中有没有 identity字段（或primary key），因为batch update 要使用主键定位纪录。

[xguoz]

使用updatebatch时，所选取的Recordset必须把KEY字段作为所选取的最前面几个字段，否则updatebatch时会出错

[Limu]

you have at least tow exact same record in then recordset that you want to batch update,but you didn't created a index to manage your record,so the error accured.