为什么提示:“多步操作产生错误”
是不是代码有错误???Private Sub ComAdd_Click()Set ADO_RS = New Recordset
Dim MyStr As String
MyStr = "SELECT * FROM kucun "
If ADO_RS.State = adStateOpen Then ADO_RS.Close
ADO_RS.Open MyStr, DB, adOpenStatic, adLockOptimistic
If ADO_RS.RecordCount <> 0 Then
ADO_RS.AddNew
For i = 1 To CoolGrid1.Cols - 1
ADO_RS.Fields("货品编号").Value = CoolGrid1.TextMatrix(i, 1)
ADO_RS.Fields("货品名称").Value = CoolGrid1.TextMatrix(i, 2)
ADO_RS.Fields("货品分类").Value = CoolGrid1.TextMatrix(i, 3)
ADO_RS.Fields("尺码").Value = CoolGrid1.TextMatrix(i, 4)
ADO_RS.Fields("颜色").Value = CoolGrid1.TextMatrix(i, 5)
ADO_RS.Fields("款式").Value = CoolGrid1.TextMatrix(i, 6)
**ADO_RS.Fields("进价").Value = CoolGrid1.TextMatrix(i, 7)** 提示着行有错误
ADO_RS.Fields("销售单价").Value = CoolGrid1.TextMatrix(i, 8)
ADO_RS.Fields("数量").Value = CoolGrid1.TextMatrix(i, 9)
ADO_RS.Fields("所在分店").Value = CoolGrid1.TextMatrix(i, 10)
ADO_RS.Fields("进货日期").Value = CoolGrid1.TextMatrix(i, 11)
ADO_RS.Fields("厂商").Value = CoolGrid1.TextMatrix(i, 12)
ADO_RS.Fields("备注").Value = CoolGrid1.TextMatrix(i, 13)
ADO_RS.Update
Next i
Else
End If
是不是代码有错误???Private Sub ComAdd_Click()Set ADO_RS = New Recordset
Dim MyStr As String
MyStr = "SELECT * FROM kucun "
If ADO_RS.State = adStateOpen Then ADO_RS.Close
ADO_RS.Open MyStr, DB, adOpenStatic, adLockOptimistic
If ADO_RS.RecordCount <> 0 Then
ADO_RS.AddNew
For i = 1 To CoolGrid1.Cols - 1
ADO_RS.Fields("货品编号").Value = CoolGrid1.TextMatrix(i, 1)
ADO_RS.Fields("货品名称").Value = CoolGrid1.TextMatrix(i, 2)
ADO_RS.Fields("货品分类").Value = CoolGrid1.TextMatrix(i, 3)
ADO_RS.Fields("尺码").Value = CoolGrid1.TextMatrix(i, 4)
ADO_RS.Fields("颜色").Value = CoolGrid1.TextMatrix(i, 5)
ADO_RS.Fields("款式").Value = CoolGrid1.TextMatrix(i, 6)
**ADO_RS.Fields("进价").Value = CoolGrid1.TextMatrix(i, 7)** 提示着行有错误
ADO_RS.Fields("销售单价").Value = CoolGrid1.TextMatrix(i, 8)
ADO_RS.Fields("数量").Value = CoolGrid1.TextMatrix(i, 9)
ADO_RS.Fields("所在分店").Value = CoolGrid1.TextMatrix(i, 10)
ADO_RS.Fields("进货日期").Value = CoolGrid1.TextMatrix(i, 11)
ADO_RS.Fields("厂商").Value = CoolGrid1.TextMatrix(i, 12)
ADO_RS.Fields("备注").Value = CoolGrid1.TextMatrix(i, 13)
ADO_RS.Update
Next i
Else
End If
解决方案 »
- VB实现关于字节间的校验和,没有atoi函数怎么办啊??
- 送分题:如何设置listview的第一列为check(就是多选框)
- VBA 保存文件 EXCEL 急急急~~~!!!!!
- google面试题之一,(不为蹭分只求探讨者进)
- ado有时不充许close,这是为什么?
- VB+MapX的问题:MapX地图的自动滚屏。
- flex栅格控件的输入方法
- 如何使用Findwindow函数及如何捕捉程序之间切换
- 如何让label字体的颜色循环改变?谢谢!
- 窗体中用鼠标拖拉可改变控件大小的问题,在线等,实现给分!
- 我就想问 RichTextBox 导入 word 文件 不出现乱码 为什么没人理啊 是问题太简单 还是 分太少了??这是今天刚给我的10分 就这些了
- 怎么样把字符串和十六进制数一起写入串口?
ADO_RS.Fields("进价").Value = cdbl(CoolGrid1.TextMatrix(i, 7))