直接就没问题了parambyname('date1').asdatetime:=datetimepicker1.date;
parambyname('date2').asdatetime:=datetimepicker2.date;试试吧。
parambyname('date2').asdatetime:=datetimepicker2.date;试试吧。
解决方案 »
- xml在IE控件中显示的问题?
- 在报表中显示图片数据库中的图片,请教如何处理
- 今年9月1日是我的生日,我来放分了!还在外地不能跟老婆一起过伤心!
- 如何把sql資料表用delphi直接匯到*.dbf表中.急在線等待
- 高分请教Interbase中的SQL语句,在线等待,急!
- 特急:操作数据库的问题???
- 怎样用delphi 6中的Database Desktop为paradox 7数据表添加密码?
- 各位大侠请问DELPHI里的反正弦函数是什么
- 怎样生成注册码?
- 哪位高手帮帮我!!
- 这个问题难道真的没有人会吗?
- select t1.*, t2.field21, t2.field2 from Table1 as t1, table2 as t2 where .....
sql.add('select * from "table.db" where date>=:date1 and date<=:date2');
sql.add('select * from "table.db" where "date">=:date1 and "date"<=:date2');
a,b:datatime;
////
a:=datetimepicker1.date;
b:=datetimepicker2.date;
with dm.query1 do
begin
close;
sql.clear;
sql.add('select * from table where date>=:date1 and date<=:date2');
parambyname('date1').asdatetime:=a;
parambyname('date2').asdatetime:=b;
ecexsql;
end;
begin
close;
sql.clear;
sql.add('select * from table where date>=:'''+date1+''' and date<=:'''+date2+'''');
parambyname('date1').asdatetime:=trunc(datetimepicker1.date);
parambyname('date2').asdatetime:=trunc(datetimepicker2.date);
open;
end;
var
i:integer;
begin
result:=formatdatetime('mm-dd-yy',sdate);
for i:=0 to length(result)-1 do
begin
if result[i]='-' then
result[i]:='/';
end;
end;with dm.query1 do
begin
close;
sql.clear;
sql.add('select * from table where between :date1 and :date2');
parambyname('date1').asstring:=convertdate(date1);
parambyname('date2').asstring:=convertdate(date2);
open;
end;
parambyname('date1').asstring:=DatetoStr(datetimepicker1.date);
parambyname('date2').asstring:=DatetoStr(datetimepicker2.date);
query1.SQL.Add('select * from table where date between cast('''+convertdate(date1)+''' as date) and cast('''+convertdate(date2)+''' as date)');我没用参数,你可以自己加上.