fieldsql = "insert into oa_data.sysdba.wgmt(WG01,WG00,WG06,WG02," & dafield& ",WJBZ,KFBZ,KCFS,XHBZ,JYBZ) " '组合字段
If (data(5) <> "") Then
data(5) = GetUserName(data(5))
End If
For i = 3 To fieldcount - 1 '组合值
valuesql = valuesql & ",'" & Replace(data(i), " ", "") & "'"
Next
valuesql = "values(0," & wg00 & "," & mMediaID & ",'" & lxfield & "'" & valuesql & ",'0'" & ",'0'" & ",'1'" & ",'0'" & ",'0'" & ")"
instrsql = fieldsql & valuesql
Dim instrsql1 As String
instrsql1 = "INSERT INTO oa_data.sysdba.wgmt__(WG00,WGMJ) VALUES(" & wg00 & ",'0')"
If (data(5) <> "") Then
data(5) = GetUserName(data(5))
End If
For i = 3 To fieldcount - 1 '组合值
valuesql = valuesql & ",'" & Replace(data(i), " ", "") & "'"
Next
valuesql = "values(0," & wg00 & "," & mMediaID & ",'" & lxfield & "'" & valuesql & ",'0'" & ",'0'" & ",'1'" & ",'0'" & ",'0'" & ")"
instrsql = fieldsql & valuesql
Dim instrsql1 As String
instrsql1 = "INSERT INTO oa_data.sysdba.wgmt__(WG00,WGMJ) VALUES(" & wg00 & ",'0')"
可以跟踪一下程序看看哪里出了问题。
可能是变量在处理的时候出了问题。