with query1 do begin close; sql.clear; sql.add('select * from table where datafield between ''' + DateToStr(begindate) + ''' and ''' + DataToStr(enddate) + ''''); open; end;
SQL SERVER 'SELECT * FROM DD WHERE (日期<''2000-02-02'') AND (日期>''2003-03-03'')'; ACCESS 'SELECT * FROM DD WHERE (日期<#2000-02-02#) AND (日期>#2003-03-03#)';
到我的信箱来拿啊
begin
close;
sql.clear;
sql.add('select * from table where datafield between ''' + DateToStr(begindate) + ''' and ''' + DataToStr(enddate) + '''');
open;
end;
'SELECT * FROM DD WHERE (日期<''2000-02-02'') AND (日期>''2003-03-03'')';
ACCESS
'SELECT * FROM DD WHERE (日期<#2000-02-02#) AND (日期>#2003-03-03#)';
大哥!!
我的邮箱是[email protected]
xiexie