Y
ylbee
Unregistered / Unconfirmed
GUEST, unregistred user!
我的query1(cacheupdate=true,requestlive=true;)的sql是这样写的:
SELECT Course.ST_DATE as"开始时间", Course.TEACHER as "老师",
Course.TEST_TYPE as "类型", Course.ORG_NO as "系",
Course.TERM as "学期", Course.GRADE aS "年级",
Course.CLASS_NO as "班级", Course.COURSE_NO as "课程号",
Course.COU_SPEC as"专业" , Course.COU_CRE as "学分", Course.COU_PERIOD as "学时",
Course.COU_EXAMINE as "考试",
Course.COU_MEMO as "备注", Cou_list.COU_NAME as "课程名称",
Cou_list.BOOK_NAME AS "署名"
FROM COURSE Course, COU_LIST Cou_list
WHERE Course.COURSE_NO=Cou_list.COURSE_NO
这时与query1连接的updatesql,不管怎样写都出错,程序运行时提示:无法更新数据,
原因是字段类型未知或找不到该字段 (我只要更改course的数据)。
如果把query1中的sql语句中 as和"汉字信息" 都去掉,重新生成updatesql的更新语句就
没有问题,程序运行正常。
高手,在保留 as和汉字信息 的情况下,如何写updatesql的语句才对?
数据库oracle 9+delphi6
SELECT Course.ST_DATE as"开始时间", Course.TEACHER as "老师",
Course.TEST_TYPE as "类型", Course.ORG_NO as "系",
Course.TERM as "学期", Course.GRADE aS "年级",
Course.CLASS_NO as "班级", Course.COURSE_NO as "课程号",
Course.COU_SPEC as"专业" , Course.COU_CRE as "学分", Course.COU_PERIOD as "学时",
Course.COU_EXAMINE as "考试",
Course.COU_MEMO as "备注", Cou_list.COU_NAME as "课程名称",
Cou_list.BOOK_NAME AS "署名"
FROM COURSE Course, COU_LIST Cou_list
WHERE Course.COURSE_NO=Cou_list.COURSE_NO
这时与query1连接的updatesql,不管怎样写都出错,程序运行时提示:无法更新数据,
原因是字段类型未知或找不到该字段 (我只要更改course的数据)。
如果把query1中的sql语句中 as和"汉字信息" 都去掉,重新生成updatesql的更新语句就
没有问题,程序运行正常。
高手,在保留 as和汉字信息 的情况下,如何写updatesql的语句才对?
数据库oracle 9+delphi6