Public Function SetUpdateCpy( _
ByVal Mode As Integer, ByVal OldStatus As String, _
ByVal NewStatus As String, ByVal UpdWho As String) As Variant Dim SQL$
Dim oraDS As Object 'OraDynaSet
Dim Vdate As String
SQL$ = "UPDATE PGCOPY" & vbCrLf & _
"set STATUS='" & NewStatus & "'" & vbCrLf
Vdate = CStr(Now())
If Mode = 0 Then
SQL$ = SQL$ & "where STATUS = '" & OldStatus & "' and UPD_WHO='" & UpdWho & "'" & vbCrLf
ElseIf Mode = 1 Then
SQL$ = SQL$ & ",FSCAPP_WHO='" & g_UserID & "' , FSCAPP_WHEN='" & Vdate & "'" & vbCrLf & _
"where STATUS = '" & OldStatus & "' and UPD_WHO='" & UpdWho & "'" & vbCrLf
end if
Result = g_oraDB.ExecuteSQL(SQL$)
表中所有字段全部为string
不知道错在什么地方?
如题,谢谢!
ByVal Mode As Integer, ByVal OldStatus As String, _
ByVal NewStatus As String, ByVal UpdWho As String) As Variant Dim SQL$
Dim oraDS As Object 'OraDynaSet
Dim Vdate As String
SQL$ = "UPDATE PGCOPY" & vbCrLf & _
"set STATUS='" & NewStatus & "'" & vbCrLf
Vdate = CStr(Now())
If Mode = 0 Then
SQL$ = SQL$ & "where STATUS = '" & OldStatus & "' and UPD_WHO='" & UpdWho & "'" & vbCrLf
ElseIf Mode = 1 Then
SQL$ = SQL$ & ",FSCAPP_WHO='" & g_UserID & "' , FSCAPP_WHEN='" & Vdate & "'" & vbCrLf & _
"where STATUS = '" & OldStatus & "' and UPD_WHO='" & UpdWho & "'" & vbCrLf
end if
Result = g_oraDB.ExecuteSQL(SQL$)
表中所有字段全部为string
不知道错在什么地方?
如题,谢谢!
SQL$ = SQL$ & ",FSCAPP_WHO='" & g_UserID & "' (这个写法有没有问题)