[access]为什么在delphi中出错？

[xiaoxinpaigu]

我在access里面运行以下语句正常

select * from TE_QA_IPQC_BATCH_INFO where INSPECT_DATE >=#2008-1-10 0:00:01#  and INSPECT_DATE <=#2008-1-10 23:00:00#  and line_no = 'LINE04' and DELIVER_INSPECT_DEPT = 'SMT' 

但是，我写到delphi里面却报错 “不正常地定义参数对象”

sql_code := 'select * from TE_QA_IPQC_BATCH_INFO where INSPECT_DATE >=#2008-1-10 0:00:01#  and INSPECT_DATE <=#2008-1-10 23:00:00#  and line_no = ''LINE04'' and DELIVER_INSPECT_DEPT = ''SMT'' ';
  Edit1.Text := sql_code ;
  With dm.QA_query do begin
    close;
    sql.Clear;
    sql.Add(Pchar(sql_code));
    open;
  end;

[xiaoxinpaigu]

sql_code := 'select * from TE_QA_IPQC_BATCH_INFO where INSPECT_DATE >=#2008-1-10 0:00:01#  and INSPECT_DATE <=#2008-1-10 23:00:00#  and line_no = ''LINE04'' and DELIVER_INSPECT_DEPT = ''SMT'' ';
  Edit1.Text := sql_code ;
  dm.QA_query.ParamCheck := False; //重点是要设置这里
  With dm.QA_query do begin
    close;
    sql.Clear;
    sql.Add(Pchar(sql_code));
    open;
  end;

呵呵自己解决了！！

[liangpei2008]

sql_code := 'select * from TE_QA_IPQC_BATCH_INFO where INSPECT_DATE >=#2008-1-10 0:00:01#  and INSPECT_DATE <=#2008-1-10 23:00:00#  and line_no = ''LINE04'' and DELIVER_INSPECT_DEPT = ''SMT'' ';
  Edit1.Text := sql_code ;
  dm.QA_query.ParameterCheck:=False;//因为Delphi将0:00:01中的冒号当做参数了~
  With dm.QA_query do begin
    close;
    sql.Clear;
    sql.Add(Pchar(sql_code));
    open;
  end;

[liangpei2008]

恭喜~