诡异问题!
INSERT INTO TB_NEW_ICTYPE_DO_MAIN (DOTYPE,DOTYPENAME,IC_TYPE,HANDLE,DEPT,AREA,TIME_STATE) VALUES ('INTEGRALTREE','积分政策','IC02','EMP999','DEPT9999','AREA00003','Q2') chr(13); SELECT S_TB_NEW_ICTYPE_DO_MAIN.CURRVAL AS new_id FROM TB_NEW_ICTYPE_DO_MAIN ;
这条语句这样子执行不了~~然后非要在分号那里换一下行才可以,
INSERT INTO TB_NEW_ICTYPE_DO_MAIN
(DOTYPE, DOTYPENAME, IC_TYPE, HANDLE, DEPT, AREA, TIME_STATE)
VALUES
('INTEGRALTREE',
'积分政策',
'IC02',
'EMP999',
'DEPT9999',
'AREA00003',
'Q2') chr
(13);
SELECT S_TB_NEW_ICTYPE_DO_MAIN.CURRVAL AS new_id
FROM TB_NEW_ICTYPE_DO_MAIN;
请问这是为什么?该如何解决?
我是在一段程序中将这条语句做为一个字符串存放的~请各位高手解答一下