大佬们,我的公式如下: select OT.FName as OT_FName, U.FName as U_FName, U.FForbidden as U_FForbidden, OAT.FName as OAT_FName, OAT.FDescription as OAT_FDescription from t_ObjectType OT join t_AccessControl AC on AC.FObjectID = OT.FObjectID and AC.FObjectType = OT.FObjectType join t_ObjectAccessType OAT on OAT.FObjectID = AC.FObjectID and OAT.FObjectType = AC.FObjectType join t_User U on AC.FUserID = U.FUserID where 1 = 1 ${if(len(treeComboBoxEditor0t_ObjectType)==0,"","AND OT.FObjectType ='"+${layer1}+"'AND OT.FObjectID ='"+${layer2}+"'")} ${if(len(comboBox1_t_User)==0,"","AND U.FName ='"+comboBox1_t_User+"'")} order by U.FName ; 其中${if(len(treeComboBoxEditor0t_ObjectType)==0,"","AND OT.FObjectType ='"+${layer1}+"'AND OT.FObjectID ='"+${layer2}+"'")}是获取下拉树一级二级的值作为查询条件的,但是报错:错误代码:11300001 数据集 [kingdee] 配置错误'$' 附近有语法错误 想问下公式怎么改 |
最佳回答 |
||||
0
|
|