我怎样写的:
INSERT INTO CARHIRE(HIRENO, CARNO, HIREITEM, DEPARTID, ISINNERUSING, HIREDATE, CARRYSUM, STVEDORECHARGE, STRANSPORTCHARGE, ST_STATION, END_STATION, LOAD_L_NUM, LOAD_S_NUM, LOAD_L_CHARGE, LOAD_S_CHARGE, CITY_LOAD, CITY_UNLOAD, SUBURB_LOAD, SUBURB_UNLOAD, DRIVERID, RETURNDATE, ARERETURN, ODOMETER, MEMO )
Values('3','湘B-20004','办公用车','生产科','T',TO_DATE('07/16/2004','MM/DD/YYYY'),0,0,0,'建安公司','自来水总公司', 0,0,0,0,0,0,0,0,'430203721017',TO_DATE('07/16/2004','MM/DD/YYYY'),'F',0 ,
''工作时间 工作内容'||CHR(13)||' 0:00-2:00 '')但提示有错误。
而直接在sql plus中没有问题
高手们 谢谢了!
INSERT INTO CARHIRE(HIRENO, CARNO, HIREITEM, DEPARTID, ISINNERUSING, HIREDATE, CARRYSUM, STVEDORECHARGE, STRANSPORTCHARGE, ST_STATION, END_STATION, LOAD_L_NUM, LOAD_S_NUM, LOAD_L_CHARGE, LOAD_S_CHARGE, CITY_LOAD, CITY_UNLOAD, SUBURB_LOAD, SUBURB_UNLOAD, DRIVERID, RETURNDATE, ARERETURN, ODOMETER, MEMO )
Values('3','湘B-20004','办公用车','生产科','T',TO_DATE('07/16/2004','MM/DD/YYYY'),0,0,0,'建安公司','自来水总公司', 0,0,0,0,0,0,0,0,'430203721017',TO_DATE('07/16/2004','MM/DD/YYYY'),'F',0 ,
''工作时间 工作内容'||CHR(13)||' 0:00-2:00 '')但提示有错误。
而直接在sql plus中没有问题
高手们 谢谢了!
可以些成比如:
query1.sql.add('
INSERT INTO CARHIRE(HIRENO, CARNO, HIREITEM, DEPARTID, ISINNERUSING, HIREDATE, CARRYSUM, STVEDORECHARGE, STRANSPORTCHARGE, ST_STATION, END_STATION, LOAD_L_NUM, LOAD_S_NUM, LOAD_L_CHARGE, LOAD_S_CHARGE, CITY_LOAD, CITY_UNLOAD, SUBURB_LOAD, SUBURB_UNLOAD, DRIVERID, RETURNDATE, ARERETURN, ODOMETER, MEMO )
Values(''3'',''湘B-20004'',''办公用车'',''生产科'',''T'',TO_DATE(''07/16/2004'',''MM/DD/YYYY''),0,0,0,''建安公司'',''自来水总公司'', 0,0,0,0,0,0,0,0,''430203721017'',TO_DATE(''07/16/2004'',''MM/DD/YYYY''),''F'',0 ,
''工作时间 工作内容''||CHR(13)||'' 0:00-2:00 '')');
query1.ExecSQL;
query1.SQL.Add('insert into khyh_t(khyh) values(:khyh)');
query1.ParamByName('khyh').AsString:='a'+chr(13)+'b';
query1.ExecSQL
query1.sql.add('
INSERT INTO CARHIRE(HIRENO, CARNO, HIREITEM, DEPARTID, ISINNERUSING, HIREDATE, CARRYSUM, STVEDORECHARGE, STRANSPORTCHARGE, ST_STATION, END_STATION, LOAD_L_NUM, LOAD_S_NUM, LOAD_L_CHARGE, LOAD_S_CHARGE, CITY_LOAD, CITY_UNLOAD, SUBURB_LOAD, SUBURB_UNLOAD, DRIVERID, RETURNDATE, ARERETURN, ODOMETER, MEMO )
Values(''3'',''湘B-20004'',''办公用车'',''生产科'',''T'',TO_DATE(''07/16/2004'',''MM/DD/YYYY''),0,0,0,''建安公司'',''自来水总公司'', 0,0,0,0,0,0,0,0,''430203721017'',TO_DATE(''07/16/2004'',''MM/DD/YYYY''),''F'',0 ,
''工作时间 工作内容''|| CHR(13) ||'' 0:00-2:00 '')');
query1.ExecSQL;
可能是少右‘