procedure TForm1.btn_countClick(Sender: TObject);
begin
adoquery1.close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from productcode where xdate between ''#'+datetostr(datetimepicker1.Datetime)+'#'' and ''#'+datetostr(datetimepicker2.Datetime)+'#'' ');
adoquery1.ExecSQL;
adoquery1.RecordCount;
end;报错内容是:
从字符串转换为datetime是发生语法错误请问怎么改正??
谢谢!!
begin
adoquery1.close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from productcode where xdate between ''#'+datetostr(datetimepicker1.Datetime)+'#'' and ''#'+datetostr(datetimepicker2.Datetime)+'#'' ');
adoquery1.ExecSQL;
adoquery1.RecordCount;
end;报错内容是:
从字符串转换为datetime是发生语法错误请问怎么改正??
谢谢!!
解决方案 »
- RzPageControl字体问题
- 请问怎样用BDE打开foxpro的dbf自由表?
- Cannot create a new transaction because capacity is exceeding.
- delphi5的一个小问题,toolbar上的SEPARATOR的隐藏问题
- 那里有李维DELPHI7高效数据库的范例下载
- 急!急!急!,在线求助,sqlserver2000的数据库如何转换为 sqlserver7.0的数据库?立即给分。
- 帮忙改一下代码!
- 为什么INSRET语句不行?
- 挑战自己 不知道有没有人能解决这个问题啊 急用
- TMemo的问题
- 如何判断一个数据集是否打开?急!!
- 如何获得hint属性
begin
adoquery1.close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from productcode where xdate between ''#'+datetimetostr(datetimepicker1.Datetime)+'#'' and ''#'+datetimetostr(datetimepicker2.Datetime)+'#'' ');
adoquery1.ExecSQL;
adoquery1.RecordCount;
end;
begin
adoquery1.close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from productcode where xdate between '+chr(39)+datetimetostr(datetimepicker1.Datetime)+chr(39)+' and '+chr(39)+datetimetostr(datetimepicker2.Datetime)+chr(39)+');
adoquery1.ExecSQL;
adoquery1.RecordCount;
end;
这样写准没错
with adoquery do begin
Close;
sql.clear;
sql.text:='select * from productcode where xdate between :Q1 and Q2';
Parameters.ParamByName('Q1').value:=datetimepicker1.Datetime;
Parameters.ParamByName('Q2').value:=datetimepicker2.Datetime;
open;
end;
adoquery1.SQL.Add('select * from productcode where xdate between #'+datetimetostr(datetimepicker1.Datetime)+'# and #'+datetimetostr(datetimepicker2.Datetime)+'#');
adoquery1.Open;
adoquery1.close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from productcode where xdate between '''+ FormatDateTime('yyyy-mm-dd',datetimepicker1.Datetime)+''' and '''+FormatDateTime(datetimetostr(datetimepicker2.Datetime+''');
adoquery1.ExecSQL;
adoquery1.RecordCount;