Tba = "CW_03_车间成本费用表1" '需要更新的表
sqlcjcb = "记录编码,本月成本" '临时表头 '记录编码,本月成本是表CW_03_车间成本费用表1中的2个字段,记录编码是主键
cjcb = "#tmp_dba_" & JELR.Tag '临时表创建
strcnn.Execute "if exists (select name from sysobjects where name='" & cjcb & "') drop table " & cjcb '检查临时表是否存在
strcnn.Execute "select top 0 " & sqlcjcb & " into " & cjcb & " from " & Tba '临时表不存在就创建
With Adocjcb
If .State = adStateOpen Then .Close
.Open "select top 0 " & sqlcjcb & " from " & cjcb, strcnn, adOpenKeyset, adLockBatchOptimistic
End With
With Adocjcb
For i = 1 To EGrid.Rows - 1
.AddNew
.Fields("记录编码") = Trim(EGrid.TextMatrix(i, 1))
.Fields("本月成本") = Val(Trim(EGrid.TextMatrix(i, 12)))
Next
End With
strcnn.BeginTrans
Adocjcb.UpdateBatch
strcnn.Execute "INSERT INTO " & Tba & "(" & sqlcjcb & ") select * from " & cjcb
strcnn.CommitTrans
Adocjcb.Close
Set Adocjcb = Nothing
strcnn.Execute "drop table " & cjcb
Save = True错误提示是:不能更新查询,因为不含用作主键的搜索列!
请高手来帮帮忙
sqlcjcb = "记录编码,本月成本" '临时表头 '记录编码,本月成本是表CW_03_车间成本费用表1中的2个字段,记录编码是主键
cjcb = "#tmp_dba_" & JELR.Tag '临时表创建
strcnn.Execute "if exists (select name from sysobjects where name='" & cjcb & "') drop table " & cjcb '检查临时表是否存在
strcnn.Execute "select top 0 " & sqlcjcb & " into " & cjcb & " from " & Tba '临时表不存在就创建
With Adocjcb
If .State = adStateOpen Then .Close
.Open "select top 0 " & sqlcjcb & " from " & cjcb, strcnn, adOpenKeyset, adLockBatchOptimistic
End With
With Adocjcb
For i = 1 To EGrid.Rows - 1
.AddNew
.Fields("记录编码") = Trim(EGrid.TextMatrix(i, 1))
.Fields("本月成本") = Val(Trim(EGrid.TextMatrix(i, 12)))
Next
End With
strcnn.BeginTrans
Adocjcb.UpdateBatch
strcnn.Execute "INSERT INTO " & Tba & "(" & sqlcjcb & ") select * from " & cjcb
strcnn.CommitTrans
Adocjcb.Close
Set Adocjcb = Nothing
strcnn.Execute "drop table " & cjcb
Save = True错误提示是:不能更新查询,因为不含用作主键的搜索列!
请高手来帮帮忙
解决方案 »
- 小问题请大侠们帮帮忙!!!谢谢了!!
- MSHFlexGrid符合条件则变色
- 做了一个OCX控件,但不能退出
- 【请高手做个项目-提供资金,详细请进】
- 在DataGrid中如果选中某一行就触发一个事件,应该用什么事件,要用到什么属性!是否能给出示范代码,谢谢!
- 因为有了VB 我的目标更加明确了 但..........
- windows下光驱调速的软件实现
- 请教高手在VB中能不能做一个按钮,模仿键盘中的PrintScreen键的功能的?
- 如何用MCI控件判断正在播放音乐文件的长度(请看里面的注释。。)
- 如何在TreeView控件加上背景图片?(不是改变被景色)
- vb查询数据库遇到的问题
- vb中如何设置网络打印的页边距
修改为strcnn.Execute "update b set b.本月成本=a.本月成本 from " & cjcb & " a, " & Tba & " b where a.记录编码=b.记录编码"
请高手进来