直接就没问题了parambyname('date1').asdatetime:=datetimepicker1.date;
parambyname('date2').asdatetime:=datetimepicker2.date;试试吧。
parambyname('date2').asdatetime:=datetimepicker2.date;试试吧。
解决方案 »
- result返回widechar该如何做?
- 如何操作將兩個字串組合成一個控件名並使用?
- ************高分求购免费的128C条形码字体!!!!***************
- 请教:TPageControl,属性页之间如何拖动?
- 数据表格显示的问题!在线等待!
- TreeView当节点展开的时候,如何屏蔽掉Click事件?
- 如果让QuickReport的预览窗口出现在我的MDI子窗口的一个Panel上?
- Listview的搜索问题,简单的我会
- 我有一个窗口转换的问题
- 对你来说,绝对简单,看看!
- 这个问题难道真的没有人会吗?
- 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)');我没用参数,你可以自己加上.