Microsoft OLE DB Provider for SQL Server 错误 '80040e14'

列名 'ChaNum' 无效。

/hr/include/DB.inc，行78


报错的位置..

'执行Insert,Update,Delete等 SQL Command
Function ExecSQL( sSQL )
Dim iRows
gCom.CommandType = 1 '1即 adCmdText
gCom.CommandText = sSQL
gCom.CommandTimeout = 300
gCom.Execute iRows '执行
ExecSQL = iRows
End Function



请大家帮帮忙急啊。

查看有没有ChaNum字段

斑竹能帮我分析下这段的意思吗？
' 调班, PayKind='S'
If ChaPayId<>"" And CDbl(ChaAmt)<>0 Then
sSQL = "INSERT INTO tmpPayData "
sSQL = sSQL & "SELECT x.StoreCd, x.EmpId, x.MonYear, x.MonMonth, '" & ChaPayId & "' AS PayID, 'S' AS PayKind, y.PayAD, "
sSQL = sSQL & "(x.ChaNum2" & ChaNum & ") * " & ChaAmt & " AS PayAmt, NULL, NULL "
sSQL = sSQL & "FROM mMonthly x "
sSQL = sSQL & "JOIN mPayItem y ON x.StoreCd=y.StoreCd AND y.PayID='" & ChaPayId & "' "
sSQL = sSQL & "WHERE x.StoreCd='" & sStore & "' "
sSQL = sSQL & "AND x.MonYear=" & sYear & " "
sSQL = sSQL & "AND x.MonMonth=" & sMonth & " "
sSQL = sSQL & "AND x.ChaNum2 > " & ChaNum & " "
If sEmp<>"" Then sSQL = sSQL & "AND x.EmpId='" & sEmp & "' "
result = ExecSQL(sSQL)
'sMsg = sMsg & sSQL & "<br><br>"
End If