首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 开发语言 > PB >

提示标示符无效?解决方案

2012-03-29 
提示标示符无效?!SELECT CASE_BASE.CASE_ID,CASE_BASE.OUT_DIAGNOSIS,CASE_BASE.OUT_RESULT,

提示标示符无效?!
SELECT "CASE_BASE"."CASE_ID",
  "CASE_BASE"."OUT_DIAGNOSIS",
  "CASE_BASE"."OUT_RESULT",
  "CASE_BASE"."OUT_ICD",
  "CASE_BASE"."HOSPITAL_INFECTION",
  "CASE_BASE"."INFECTION_RESULT",
  "CASE_BASE"."INFECTION_ICD",
  "CASE_BASE"."PATHOLOGY_DIAGNOSIS",
  "CASE_BASE"."PATHOLOGY_DIAGNOSIS_ICD",
  "CASE_BASE"."EXTEND_REASON",
  "CASE_BASE"."EXTEND_REASON_ICD",
  "CASE_BASE"."MEDICINE_ANAPHYLACTIC",
  "CASE_BASE"."HBSAG",
  "CASE_BASE"."HCVAB",
  "CASE_BASE"."HIVAB",
  "CASE_BASE"."CLINIC_OUT",
  "CASE_BASE"."IN_OUT",
  "CASE_BASE"."OPERATION",
  "CASE_BASE"."CLINIC_PATHOLOGY",
  "CASE_BASE"."RADIO_PATHOLOGY",
  "CASE_BASE"."SALVAGE_TIMES",
  "CASE_BASE"."SUCCESS_TIMES",
  "CASE_BASE"."DEPT_DIRECTOR",
  "CASE_BASE"."DIRECTOR_DOCTOR",
  "CASE_BASE"."MASTER_DOCTOR",
  "CASE_BASE"."IN_DOCTOR",
  "CASE_BASE"."STUDY_DOCTOR",
  "CASE_BASE"."PRACTICE_DOCTOR",
  "CASE_BASE"."PRACTICE_DOCTOR2",
  "CASE_BASE"."CODER",
  "CASE_BASE"."CASE_QUALITY",
  "CASE_BASE"."QUALITY_DOCTOR",
  "CASE_BASE"."QUALITY_NURSE",
  "CASE_BASE"."QUALITY_DATE",
  1 OPERATION_FLAG,
  1 COLUMN_END,
  '' COLUMN_SUBDIAGNOSIS,
  '' COLUMN_INFECTION,
  "CASE_BASE"."XYDYFY_ICD_ATTACH",
  '' XYDYFY_ICD_ATTACH_NAME,
  "CASE_BASE"."DIAGNOSIS_REASON",
  "CASE_BASE"."PATHOLOGY_NO",
  "CASE_BASE"."SICK_DATE"
  FROM "CASE_BASE"
 WHERE CASE_ID = :as_id


高手帮忙看下这段语句 提示ORA-00904:"CASE_BASE"."SICK_DATE" 标示符无效  
这事咋回事?请教下各位

[解决办法]
没有SICK_DATE这一列.
[解决办法]
SICK_DATE 列是否存在?

热点排行