我的纪录集是这样打开的:
Set RS = New Recordset
mySQL = "select companyinfo.*,checkbook.[check start number],checkbook.[check end number],checkbook.[buying date],checkbook.[bank name],checkbook.[bank address],checkbook.companynumber from companyinfo left join checkbook on companyinfo.[company number]=checkbook.[companynumber] and companyinfo.[newcheckdate]=checkbook.[buying date]"
RS.Open mySQL, db, adOpenStatic, adLockOptimistic companyinfo 表的主键是company number,checkbook表的主键是自动添加的序列号。
rs.addnew后rs.updatebatch affectall 没有问题。
但直接修改后 rs.UpdateBatch adAffectAll 报错: insufficient key column information for updating or refreshing.
那位能帮我解决呀?
Set RS = New Recordset
mySQL = "select companyinfo.*,checkbook.[check start number],checkbook.[check end number],checkbook.[buying date],checkbook.[bank name],checkbook.[bank address],checkbook.companynumber from companyinfo left join checkbook on companyinfo.[company number]=checkbook.[companynumber] and companyinfo.[newcheckdate]=checkbook.[buying date]"
RS.Open mySQL, db, adOpenStatic, adLockOptimistic companyinfo 表的主键是company number,checkbook表的主键是自动添加的序列号。
rs.addnew后rs.updatebatch affectall 没有问题。
但直接修改后 rs.UpdateBatch adAffectAll 报错: insufficient key column information for updating or refreshing.
那位能帮我解决呀?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货