源程序如下:
Select table.部门,;
iif(talbe.性别="男",1,0) as 男,;
iif(talbe.性别='女',1,0) as 女,;
iif(talbe.文化程度="大学本科",1,0) as 大学本科,;
iif(talbe.文化程度="大学专科",1,0) as 大学专科,;
iif(inlist(talbe.职务,'工程师','技术员','总工程师'),1,0) as 技术人员,;
iif(inlist(talbe.职务,'总经理','经理','销售经理'),1,0)as 管理人员;
from table.dbf into cursor query1
Select table.部门 as 部门,;
sum(男) as 男,;
sum(女) as 女,;
sum(大学本科) as 大学本科,;
sum(大学专科) as 大学专科,;
sum(技术人员) as 技术人员,;
sum(管理人员) as 管理人员;
from query1 into cursor query1;
group by 部门
为什么程序执行到iff语句时提示:“不能识别的关键字”?错在哪里了?请高手指教,谢谢