Dim conn As ADODB.Connection
Dim rs As New ADODB.Recordset
Set conn = New ADODB.Connection
conn.ConnectionString = ConnectString
conn.CursorLocation = adUseClient
conn.Open '连接数据库
'判断材料库存表中是否有当前材料的记录rs.Open "select * from clkc where 材料名称='" & Trim(txtfields(0).Text) & "'", conn, adOpenKeyset, adLockBatchOptimistic
If rs.EOF = True Then
MsgBox "该仓库没有该种材料可出库!", vbOKOnly + vbExclamation, "警告"
txtfields(0).SetFocus
Exit Sub
Else
If Val(rs![重量]) - Val(txtfields(1).Text) < 0 Then
MsgBox "该仓库没有足够数量的该种材料可出库!", vbOKOnly + vbExclamation, "警告"
txtfields(1).SetFocus
Exit Sub
Else
就是这下面一步,他不会更新数据!!!
rs![重量] = Val(rs![重量]) - Val(Trim(txtfields(1).Text))
rs.Update
rs.Close
各位高手帮忙看看了!!!先谢过
!!!!!
Dim rs As New ADODB.Recordset
Set conn = New ADODB.Connection
conn.ConnectionString = ConnectString
conn.CursorLocation = adUseClient
conn.Open '连接数据库
'判断材料库存表中是否有当前材料的记录rs.Open "select * from clkc where 材料名称='" & Trim(txtfields(0).Text) & "'", conn, adOpenKeyset, adLockBatchOptimistic
If rs.EOF = True Then
MsgBox "该仓库没有该种材料可出库!", vbOKOnly + vbExclamation, "警告"
txtfields(0).SetFocus
Exit Sub
Else
If Val(rs![重量]) - Val(txtfields(1).Text) < 0 Then
MsgBox "该仓库没有足够数量的该种材料可出库!", vbOKOnly + vbExclamation, "警告"
txtfields(1).SetFocus
Exit Sub
Else
就是这下面一步,他不会更新数据!!!
rs![重量] = Val(rs![重量]) - Val(Trim(txtfields(1).Text))
rs.Update
rs.Close
各位高手帮忙看看了!!!先谢过
!!!!!
你说的update该怎么用呢??
rs.fields!(重量)=3
我该怎么编呢?