标题: 安装后，出现以下错误，麻烦处理下 [打印本页] 作者: 陈勉生 时间: 2020-8-11 10:37 标题: 安装后，出现以下错误，麻烦处理下 升级后，出现错误：执行SQ错误， Sqlselect distinct Employeefixemp id from
Employeefix, Employeeunfix WHERE (
Employeefixemp id=21746) AND(Employeefixetype id in (1)
)AND(((Employeefix.efc00="1)and (
Employeefix. efd05 is not null and Employeefix.efdo5 s
Employeeunfix bgn date )or Employeefix.efdo1 <'2005-06-30
00:000))and10in( select type from ext2017务序列历史记
s A where Employeefixemp id=A.emp id and
disable date="9999-12-31)))AND((
Employeefixemp id=Employeeunfixemp id and
Employeeunfixbgn date==Employeefixban date and
Employeeunfixbgndate<=Employeefixend date ))AND
Employeefibgn date<="2020-07-31 00: 00: 00 and
Employeefix.end date==2020-07-01 00: 00: 00 AND
Employeeunfix bgn date="2020-07-01 00: 00:00 and
Employeeunfix.end date=2020-07-31 00: 00: 00)AND(
Employeefix implement date*="2020-07-01 00:00:00 and
Employeefix. disable date>= 2020-07-01 00: 00: 00 AND
Employeeunfix.implement dates=2020-07-01 00: 00: 00and
Employeeunfix. disable date="2020-07-01 00: 00: 00)
Invalid object name＇ext_2017职务序列历史记录
at
System Data. Sql Client Sqlcommand Executereader(Commande
havior cmde
ehavior. Runbehavior runbehavior Boolean
returnstream)
at
System Data. Sqlclient. Sql Command. Executereader(Commandbe
havior behavior
at
Svstemdata Salientsqlcommand System. Data Idbcommand E
xecutereader(Command Behaviorbehavior)
at Salary. Common Context Context. Executereader(String se
Int32 timeout