提示:sql语句未正常结束。 我分析是否与oracle连接串有关?在我公司所有机器运行均正常,可是在客户那里出现问题! 经跟踪sql未发现问题!源代码: thesql:='insert into fdcm_evlobj select CASEID,BLOCKID,HOUSECLASS,HOUSESTRUCTURE,'+ 'DIRECT,MAINDIRECT,TOTALLAYERS,LAYER,ELIAVATOR,ROOMS,'+ 'CONSTRUCTAREA,SHINESTATE,'''',QAULITY,'+ 'USEDFLAG,'''','''+vSEQ+''' from fdcm_baseinfo '+limsql; with q_preevl do begin Close; SQL.Clear; SQL.Add(thesql); execsql; ***********error end; //清空评估值 thesql:='update fdcm_evlobj set evlprice='''',evldate='''' where seq='''+vseq+''''; with q_preevl do begin Close; SQL.Clear; SQL.Add(thesql); execsql; end;
我分析是否与oracle连接串有关?在我公司所有机器运行均正常,可是在客户那里出现问题!
经跟踪sql未发现问题!源代码:
thesql:='insert into fdcm_evlobj select CASEID,BLOCKID,HOUSECLASS,HOUSESTRUCTURE,'+
'DIRECT,MAINDIRECT,TOTALLAYERS,LAYER,ELIAVATOR,ROOMS,'+
'CONSTRUCTAREA,SHINESTATE,'''',QAULITY,'+
'USEDFLAG,'''','''+vSEQ+''' from fdcm_baseinfo '+limsql;
with q_preevl do
begin
Close;
SQL.Clear;
SQL.Add(thesql);
execsql; ***********error
end;
//清空评估值
thesql:='update fdcm_evlobj set evlprice='''',evldate='''' where seq='''+vseq+'''';
with q_preevl do
begin
Close;
SQL.Clear;
SQL.Add(thesql);
execsql;
end;
DML语句用Query.ExecSQL