作者:7-好 | 来源:互联网 | 2022-12-08 17:56
我已经浏览了类似的帖子,并且无法在这里找出导致我的错误的确切原因.从我可以告诉我的语法是正确的,我已经包含了我的构建代码,它正常运行直到执行SQL行.
rs.MoveFirst
If Me.chkBBB = True Then
Do Until rs.EOF
strBBB = rs!BBB
strBrktDet1 = Left(strBBB, 2)
strBrktDet2 = Right(strBBB, 8)
If strBrktDet1 = "99" Then varBracket = -1
If strBrktDet1 = "98" Then varBracket = 0
strBPINo = Nz(DLookup("[BPINo]", "[Caliper Master]", "[BBB] LIKE" & "'*" & strBrktDet2 & "'"), "N/A")
strCentric = Nz(DLookup("[CentricItemNo]", "[Caliper Master]", "[BBB] LIKE" & "'*" & strBrktDet2 & "'"), "N/A")
strCardOneNo= Nz(DLookup("[A1CardoneItemNo]", "[Caliper Master]", "[BBB] LIKE" & "'*" & strBrktDet2 & "'"), "N/A")
If strBPINo = "" Or Null Then strBPINo = "N/A"
intQty = rs!Need
strSQL = "INSERT INTO tblCaliperOrderDetails (OrderNumber, Cardone, BBB, BPI, Centric, WithBracket, QuantityNd) VALUE(" & lngOrderNo & ", '" & strCardoneNo & "', '" & strBBB & "', '" & strBPINo & "', '" & strCentric & "', '" & varBracket & "', " & intQty & ")"
Debug.Print strSQL
DoCmd.RunSQL strSQL
rs.MoveNext
Loop
立即返回窗口
INSERT INTO tblCaliperOrderDetails (OrderNumber, Cardone, BBB, BPI, Centric, WithBracket, QuantityNd) VALUE(18190059, 'N/A', '99-00644L-C', 'N/A', '42172', '-1', 208)
订单号,QuantityNd是数字字段,所有其他都是文本字段,WithBracket是三态复选框的控制源.
据我所知,一切正常,在线SQL检查员告诉我我的语法是正确的,而且我已经在这个问题上待了一整天,所以我想我会问更清晰的眼睛和更聪明的头脑.
1> user1443098..:
SQL关键字是"VALUES"而非"VALUE"