|
版本: |
|
小版本号: |
|
|
|
数据库: |
Oracle |
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
|
浏览器: |
|
|
|
程序运行正常,在编辑器里点击测试也正常,但是无法进去设计页面,无法修改。select EXAMINE_TOTAL.*,EXAMINE_EMPLOYEE.NAME as NAME,EXAMINE_EMPLOYEE.TITLE_NAME as TITLE_NAME,EXAMINE_EMPLOYEE.WORK_DATE as WORK_DATE,EXAMINE_AB.SELF as SELF,EXAMINE_EMPLOYEE.EXAM_CLASS as EXAM_CLASS,EXAMINE_EMPLOYEE.DEPARTMENT as DEPARTMENT,EXAMINE_EMPLOYEE.JOB_FLAG as JOB_FLAG,EXAMINE_EMPLOYEE.DUTY_STATUS as DUTY_STATUS,EXAMINE_EMPLOYEE.IN_RANGE as IN_RANGE,(sql.NVL ( EXAMINE_TOTAL.GROUPSCORE , -1)) as GROUPSCORE_NVL from EXAMINE_TOTAL EXAMINE_TOTAL optional join EXAMINE_EMPLOYEE EXAMINE_EMPLOYEE on EXAMINE_TOTAL.EMPNO = EXAMINE_EMPLOYEE.EMPNO AND EXAMINE_TOTAL.TDATE = EXAMINE_EMPLOYEE.TDATE optional join EXAMINE_AB EXAMINE_AB on EXAMINE_TOTAL.EMPNO = EXAMINE_AB.EMPNO AND EXAMINE_TOTAL.TDATE = EXAMINE_AB.TDATE
请帮忙查看!
|
|