search

tieuquyngok1995 / ToolSupportUchida

1 stars 1 forks source link

test #18

Closed tieuquyngok1995 closed 3 years ago

tieuquyngok1995 commented 3 years ago

sSql &= " Upddate= NULLIF('" & Now.ToString("yyyMMdd") & "','')" & vbCrLf sSql &= ",Updtime= NULLIF('" & Now.ToString("HHmmss") & "','')" & vbCrLf

                If siCurrentProc <> "" Then
                    sSql &= ",CurrentProc='" & siCurrentProc & "'" & vbCrLf
                End If
                If siCurrentProcProgress <> "" Then
                    sSql &= ",CurrentProcProgress= NULLIF('" & siCurrentProcProgress & "','')" & vbCrLf
                End If
                If siCurrentProcStatus <> "" Then
                    sSql &= ",CurrentProcStatus= NULLIF('" & siCurrentProcStatus & "','')" & vbCrLf
                End If
                If siCurrentProcStartDateTime <> "" Then
                    sSql &= ",CurrentProcStartDateTime= NULLIF('" & siCurrentProcStartDateTime & "','')" & vbCrLf
                End If