adoquery1.Close;
ADOQuery1.SQL.Clear;
s:='insert into a02(id,timecode,timename,variable,time,date,re,callsign,voy,port) select id,timecode,timename,variable,time,date,re,callsign,voy,port from a02t';
ADOQuery1.SQL.Add(s);
ADOQuery1.ExecSQL;
执行的时候报语法错误,
adoquery1.Close;
ADOQuery1.SQL.Clear;
s:='insert into a02 select id,timecode,timename,variable,time,date,re,callsign,voy,port from a02t';
这样没有抱错,怎么回事啊?请帮忙看看,谢谢了!
ADOQuery1.SQL.Clear;
s:='insert into a02(id,timecode,timename,variable,time,date,re,callsign,voy,port) select id,timecode,timename,variable,time,date,re,callsign,voy,port from a02t';
ADOQuery1.SQL.Add(s);
ADOQuery1.ExecSQL;
执行的时候报语法错误,
adoquery1.Close;
ADOQuery1.SQL.Clear;
s:='insert into a02 select id,timecode,timename,variable,time,date,re,callsign,voy,port from a02t';
这样没有抱错,怎么回事啊?请帮忙看看,谢谢了!
'insert into a02 select [id],[timecode],[timename],[variable],[time],[date],[re],[callsign],[voy],[port] from a02t';