sql.Add('select * from Nation where Born_Date between ''''+'1998-5-19'+''''+' and '+''''+'1992-5-19'+'''');
解决方案 »
- 多个TIdTcpClient是否会提高效率。
- TCPClient怎么把视频信号发出去
- 如何正确拼QUERY的SQL语句串,确保引号匹配正确
- 初学HOOK,我编了一个按键精灵程序,有一个小问题.请大家帮帮忙.
- 请问uses LbCipher, LbString单元是什么来的?
- 请问在DELPHI7中如何实现数据库的备份和恢复。
- sql字符串中包含单引号时怎么处理?
- 从excel中读取数据
- 单位需要从今天开始,全身心投入Delphi的研究中去,请各位前辈多多指点!
- 那位高人能指点一下,如何制作像realplayer那样的状态栏,谢谢,必定给分
- 急问
- 如何用BDE连接ACCESS. 问了若干次没人给我一个完整的答案。
Query1.Close;
Query1.SQL.Clear;
Query1.SQL.Add('Select * from Nation where Born_Date between :ADate and :BDate');
Query1.Params[0].AsDate = StrToInt('1998-5-19');
Query1.Params[1].AsDate = StrToInt('1992-5-19');
Query1.Prepare;
Query1.Open;
end;
SQLText:String;
begin
Query1.Close;
Query1.SQL.Clear;
//如果数据库为SQLServer
SQLText:=Format('Select * From Nation where (Born_Date>=''%s'') '+
' AND (Born_Date<=''%s'') ',['1992-5-19','1998-5-19']);
//如果数据库为Accesss
SQLText:=Format('Select * From Nation where (Born_Date>=#%s#) '+
' AND (Born_Date<=#%s#)',['1992-5-19','1998-5-19']);
Query1.SQL.Add(SQLText);
Query1.Prepare;
Query1.Open;
end;
A必须小于B,否则就查询不出来
你应该写成这样
between 1992-5-19 and 1998-5-19');
你所说的方法也试过的,找了来还是为空,我真不知道是哪儿出了问题。
with query1 do
begin
close; sql.Clear;
sql.Add('select Born_Date,sex from Nation where Born_Date between 1980-01-01 and 2000-12-31 GROUP BY Born_Date,sex');
open;
end;
ex:csSQL := 'select * from Nation where Born_Date between TO_DATE(''1998-5-19'')and TO_DATE(''1992-5-19'')';
csSQL := 'select * from Nation where Born_Date between TO_DATE(''''1998-5-19'''')and TO_DATE(''''1992-5-19'''')';
query1.close;
query1;sql.clear;
query1.SQL.Add('Select * from Nation where Born_Date between :ADate and :BDate');
query1.Params[0].value:=strtodate('1992-5-19');
query1.Params[2].value:=strtodate('1998-5-19');
query1.open;
where [服务时间] between #1992-5-19# and #1998-5-19#
select * from Nation where Born_Date >'12/05/2002' and Born_Date <='16/05/2002'