把SQL参数查询改成不要参数怎么改
下面是一我写的一个SQL带参数查询，
ADOQuery1->SQL->Add("select * from LEDGER x where LDATE in (select max(LDATE) from LEDGER where YGNO = x.YGNO and LDATE <=:DA) order by YGNO ");
ADOQuery1->Parameters->ParamByName("DA")->Value=DateTimePicker1->DateTime;
我想把ParamByName("DA")参数去掉，改成变量查询，直接写到SQL的语句里，不知怎么改
改成这样好象不行
TDateTime AA=DateTimePicker1->DateTime;
ADOQuery1->SQL->Add("select * from LEDGER x where LDATE in (select max(LDATE) from LEDGER where YGNO = x.YGNO and LDATE <='"+AA+"') order by YGNO ");
本来程序是通过的，只是想学学时间变量怎么写到SQL语句里的，谢谢各位。
问题点数：20、回复次数：2Top
1 楼happyct（绿叶对大树的情怀）回复于 2005-05-17 11:50:40 得分 10
SqlServer里面可以直接用双引号比较Top
2 楼h98458（零点起飞）回复于 2005-05-17 14:12:54 得分 10
where YGNO = x.YGNO and LDATE <='"+String(DateTimePicker1->Date)+"'Top
