7,787
社区成员
发帖
与我相关
我的任务
分享为什么不能这么更新数据?
请看下面代码
rs.Open "select current_score_a,score_total_a from basketball_matchdetails " _
& "where match_no='" & Trim(Match_num) & "' and current_no='" & Trim(Label3.Caption) & "'", cn, adOpenStatic, adLockOptimistic
rs!current_score_a = rs!current_score_a + num3
rs!score_total_a = rs!score_total_a + num3
rs.Update
rs.Close
当我连续点击加分按钮时 会出现下面提示
key column informaion is unsufficient or incorrect ,too many row were
affect by update
点击时间间隔长不会有此现象 请指教!
rs.Open "select current_score_a,score_total_a from basketball_matchdetails " _
& "where match_no='" & Trim(Match_num) & "' and current_no='" & Trim(Label3.Caption) & "'", cn, adOpenStatic, adLockOptimistic
rs!current_score_a = rs!current_score_a + num3
rs!score_total_a = rs!score_total_a + num3
rs.Update
rs.Close
当我连续点击加分按钮时 会出现下面提示
key column informaion is unsufficient or incorrect ,too many row were
affect by update
点击时间间隔长不会有此现象 请指教!
...全文
请发表友善的回复…
发表回复
lilyzhang 2001-05-11
- 打赏
- 举报
有点眉目了
liu_feng_fly 2001-05-11
- 打赏
- 举报
那你可以增加存盘功能,就像vb一样,呵呵,不满意就再加一个自动存盘,加一个TIME控件,一段时间判断一下是否有改动,有的话就存盘
lilyzhang 2001-05-09
- 打赏
- 举报
用update tablename set ...有什么不一样吗
lilyzhang 2001-05-09
- 打赏
- 举报
用悲观锁也不行 结构有什么问题,详细点
lilyzhang 2001-05-09
- 打赏
- 举报
怎么不能打分了?
lilyzhang 2001-05-09
- 打赏
- 举报
可以了
lilyzhang 2001-05-09
- 打赏
- 举报
谢谢
lilyzhang 2001-05-09
- 打赏
- 举报
good
lilyzhang 2001-05-09
- 打赏
- 举报
ok
lilyzhang 2001-05-09
- 打赏
- 举报
有道理 如果突然断电 或其他原因让程序中断记录的变量值不就全丢失了?
liu_feng_fly 2001-05-09
- 打赏
- 举报
那你试一试用一个变量来记录变化，等到form被关闭时再一起存到数据库中呢？
这样就不会频繁的开记录集，关记录集了
这样就不会频繁的开记录集，关记录集了
hzh_wen_x 2001-05-09
- 打赏
- 举报
保存时有重复，修改一下结构吧！！！
liu_feng_fly 2001-05-08
- 打赏
- 举报
把adLockOptimistic改成adLockPessimistic
wwq_jeff 2001-05-08
- 打赏
- 举报
Update tablename set fieldname = values[,...]
lilyzhang 2001-05-08
- 打赏
- 举报
悲观锁是那个? 不好意思
liu_feng_fly 2001-05-08
- 打赏
- 举报
用悲观锁呢？？
lilyzhang 2001-05-08
- 打赏
- 举报
我已经在代码中用了update呀
lilyzhang 2001-05-08
- 打赏
- 举报
I have done as what you told
but it tell me :
row cannot be located for updating,some values may have been changed
since it was last read
but it tell me :
row cannot be located for updating,some values may have been changed
since it was last read
liu_feng_fly 2001-05-08
- 打赏
- 举报
同意playyuer(女爱㊣)
wwq_jeff 2001-05-08
- 打赏
- 举报
使用Update语句，效果要好些，不仅仅是在速度上。
加载更多回复（1）
