X
xueji93660007
Unregistered / Unconfirmed
GUEST, unregistred user!
我的语句:
TMP_SQL:='INSERT INTO "lsjs2.dbf" SELECT * FROM "lsjs1.dbf" WHERE FP_no>=:KSRQ OR FP_no<=:JZRQ';
QUERY1.CLOSE;
QUERY1.SQL.Clear;
QUERY1.SQL.Add(TMP_SQL);
BEGIN
QUERY1.ParamByName('KSRQ').Asstring:='02523705';
QUERY1.ParamByName('JZRQ').Asstring:='02523710';
QUERY1.Prepare;
END;
QUERY1.ExecSQL;
QUERY1.CLOSE;
执行后 Where 条件不起作用,什么原因?谢谢![?]
TMP_SQL:='INSERT INTO "lsjs2.dbf" SELECT * FROM "lsjs1.dbf" WHERE FP_no>=:KSRQ OR FP_no<=:JZRQ';
QUERY1.CLOSE;
QUERY1.SQL.Clear;
QUERY1.SQL.Add(TMP_SQL);
BEGIN
QUERY1.ParamByName('KSRQ').Asstring:='02523705';
QUERY1.ParamByName('JZRQ').Asstring:='02523710';
QUERY1.Prepare;
END;
QUERY1.ExecSQL;
QUERY1.CLOSE;
执行后 Where 条件不起作用,什么原因?谢谢![?]