1,216
社区成员
发帖
与我相关
我的任务
分享
C_ID M_ID P_ID
20120102 01001 0
20120103 01001 0
20120104 01001 1
20120105 01003 1
20120106 02001 0
20120107 02001 2
20120108 02001 0
20120109 02001 1
20120110 01003 2
...
C_ID M_ID P_ID
20120102 01001 ok
20120103 01001 ok
20120104 01001 Fail
20120105 01003 Fail
20120106 02001 ok
20120107 02001 Unknow
20120108 02001 ok
20120109 02001 Fail
20120110 01003 Unknow
...
function Str_Days(byval str_D as string) as string
if astr_D ="0"then
Str_Days="ok"
elseif astr_D ="1"then
Str_Days="Fail"
elseif astr_D ="2"then
Str_Days="Unknow"
endif
end function
select C_ID,M_ID,Str_Days(P_ID) from P_History
DB_Search_TxT = "Select " & Str_PM_Result(PM_Comment) & " from Case_PM_Schedule_History"
出现错误: -2147217900 语法错误(操作符丢失)正查询表达式 'For Schedule PM' 中
'定义PM Result String
Function Str_PM_Result(ByVal str_P As String) As String
If str_P = "0" Then
Str_PM_Result = "For Schedule PM"
ElseIf str_P = "1" Then
Str_PM_Result = "For Down PM"
Else
Str_PM_Result = "For Schedule PM"
End If
End Function