注册

创建视图出现语法分析出错 (-2007)

莫的感情_ 2025/10/13 99 3 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM Database Server 64 V8
【操作系统】:Windows 11
【CPU】: 64 位操作系统, 基于 x64 的处理器
【问题描述】*:
执行创建视图SQL语句报错
SQL:
CREATE VIEW WF_EmpWorks
(
PRI,
WorkID,
IsRead,
Starter,
StarterName,
WFState,
FK_Dept,
DeptName,
FK_Flow,
FlowName,
PWorkID,
PFlowNo,
FK_Node,
NodeName,
Title,
RDT,
ADT,
SDT,
FK_Emp,
FID,
FK_FlowSort,
SysType,
SDTOfNode,
SendDT,
GuestNo,
GuestName,
BillNo,
TodoEmps,
TodoEmpsNum,
TodoSta,
TaskSta,
FlowNote,
ListType,
Sender,
AtPara,
DomainExt,
OrgNo,
FlowIdx,
FlowSortIdx
)
AS
SELECT
A.PRI,
A.WorkID,
B.IsRead,
A.Starter,
A.StarterName,
A.WFState,
A.FK_Dept,
A.DeptName,
A.FK_Flow,
A.FlowName,
A.PWorkID,
A.PFlowNo,
B.FK_Node,
B.NodeName AS NodeName,
A.Title,
A.RDT,
B.RDT AS ADT,
B.SDT,
B.FK_Emp,
B.FID,
A.FK_FlowSort,
A.SysType,
A.SDTOfNode,
A.SendDT,
A.GuestNo,
A.GuestName,
A.BillNo,
A.TodoEmps,
A.TodoEmpsNum,
A.TodoSta,
A.TaskSta,
A.FlowNote,
0 AS ListType,
A.Sender,
A.AtPara,
A.DomainExt,
A.OrgNo,
C.Idx AS FlowIdx,
D.Idx AS FlowSortIdx
FROM
WF_GenerWorkFlow A
JOIN
WF_GenerWorkerlist B ON A.WorkID = B.WorkID AND A.FK_Node = B.FK_Node
JOIN
WF_Flow C ON A.FK_Flow = C.No
JOIN
WF_FlowSort D ON A.FK_FlowSort = D.No
WHERE
B.IsEnable = 1
AND B.IsPass = 0
AND A.WFState <> 0
AND A.WFState <> 4
AND B.WhoExeIt <> 1
UNION
SELECT
A.PRI,
A.WorkID,
B.Sta AS IsRead,
A.Starter,
A.StarterName,
2 AS WFState,
A.FK_Dept,
A.DeptName,
A.FK_Flow,
A.FlowName,
A.PWorkID,
A.PFlowNo,
B.NodeIDCC AS FK_Node,
B.NodeIDCCName AS NodeName,
A.Title,
A.RDT,
B.RDT AS ADT,
B.RDT AS SDT,
B.CCTo AS FK_Emp,
B.FID,
A.FK_FlowSort,
A.SysType,
A.SDTOfNode,
A.SendDT,
A.GuestNo,
A.GuestName,
A.BillNo,
A.TodoEmps,
A.TodoEmpsNum,
0 AS TodoSta,
0 AS TaskSta,
A.FlowNote,
1 AS ListType,
B.RecEmpNo AS Sender,
CONCAT('@IsCC=1', '@NodeIDWork=', B.NodeIDWork, A.AtPara) AS AtPara,
A.DomainExt,
A.OrgNo,
C.Idx AS FlowIdx,
D.Idx AS FlowSortIdx
FROM
WF_GenerWorkFlow A
JOIN
WF_CCList B ON A.WorkID = B.WorkID
JOIN
WF_Flow C ON A.FK_Flow = C.No
JOIN
WF_FlowSort D ON A.FK_FlowSort = D.No
WHERE
B.Sta <= 1
AND B.InEmpWorks = 1
AND A.WFState <> 0
报错信息:
[42000] 第 1 行, 第 25 列[view]附近出现错误:
语法分析出错 (-2007)

回答 0
暂无回答
扫一扫
联系客服