E
EricER
Unregistered / Unconfirmed
GUEST, unregistred user!
Select TaskCode from TB_SecretTask
where ((SenderID In (Select LoginID from TB_Login where Department=epartment and Authority>=:Authority) and TaskStatus=:TaskStatus1)
or (ReceiverID In (Select LoginID from TB_Login where Department=epartment1 and Authority>=:Authority1) and TaskStatus=:TaskStatus2))
and IsFinish=:IsFinish Order By TaskCode Desc
语句如上,在2000上能顺利执行,但在ME或98下出现类似如下错误:
SQL Error [MDA 驱动程序错误] 资料类型不符合
先50,如先我之前解决再加100。
where ((SenderID In (Select LoginID from TB_Login where Department=epartment and Authority>=:Authority) and TaskStatus=:TaskStatus1)
or (ReceiverID In (Select LoginID from TB_Login where Department=epartment1 and Authority>=:Authority1) and TaskStatus=:TaskStatus2))
and IsFinish=:IsFinish Order By TaskCode Desc
语句如上,在2000上能顺利执行,但在ME或98下出现类似如下错误:
SQL Error [MDA 驱动程序错误] 资料类型不符合
先50,如先我之前解决再加100。