query1.close; query1.sql.text := 'select * from table1 where datetime1 = :date1'; query1.params.fieldbyname('data1').asdatetime := now; query1.Open;
adoquery1.close; adoquery1.sql.clear; adoquery1.sql.add('select * from 表名 where 日期=:As'); adoquery1.Parameters.ParamByName('As').AsDateTime:=now(); adoquery1.Open;
query1.close; query1.sql.text := 'select * from table1 where datetime1 = :date1'; query1.params.fieldbyname('data1').asdatetime := date; query1.Prepare; query1.Open;
楼上3个没一个对的我是写在QUERY1的SQL里的
Filter : 字段 = Now
query1.close; query1.sql.clear; query1.sql.add('select * from table1 where datetime1 = date()'); query1.Open
楼上3个没一个对的我是写在QUERY1的SQL里的 --------------------------------------------- 什么意思?你是设计时就写在query的sql属性里? 那么只要写select * from table1 where datetime1 = date()就可以了,但最好还是在运行时执行就象楼上几位的方法。
query1.close; query1.sql.clear; query1.sql.add('select * from table1 where 日期 = datetimetostr(now)'); query1.Open 'select * from table1 where 日期 = datetimetostr(date)'
select * from table1 where datetime1 = getdate()
如果你表里面日期字段是保存纯日期型的,应该这样写 select * from table1 where datetime1 = CONVERT(CHAR(10),getdate(),120)
报错 capability not supported adoquery1的SQL里是这样写的 select * from mytransaction.db where 日期 = datetimetostr(now)日期格式是这样的 2003-8-23
query1.sql.text := 'select * from table1 where datetime1 = :date1';
query1.params.fieldbyname('data1').asdatetime := now;
query1.Open;
adoquery1.sql.clear;
adoquery1.sql.add('select * from 表名 where 日期=:As');
adoquery1.Parameters.ParamByName('As').AsDateTime:=now();
adoquery1.Open;
query1.sql.text := 'select * from table1 where datetime1 = :date1';
query1.params.fieldbyname('data1').asdatetime := date;
query1.Prepare;
query1.Open;
query1.sql.clear;
query1.sql.add('select * from table1 where datetime1 = date()');
query1.Open
---------------------------------------------
什么意思?你是设计时就写在query的sql属性里?
那么只要写select * from table1 where datetime1 = date()就可以了,但最好还是在运行时执行就象楼上几位的方法。
query1.sql.clear;
query1.sql.add('select * from table1 where 日期 = datetimetostr(now)');
query1.Open
'select * from table1 where 日期 = datetimetostr(date)'
select * from table1 where datetime1 = CONVERT(CHAR(10),getdate(),120)
capability not supported
adoquery1的SQL里是这样写的
select * from mytransaction.db where 日期 = datetimetostr(now)日期格式是这样的
2003-8-23
select * from table1 where datetime1=left(getdate(),11)
update mytransaction.db
set 日期=getdate()
where(条件)//如果想更新所有的日期,就不用条件了
最后别忘了调用QUERY1.EXECUTE,不要用QUERY1.OPEN或QUERY1.ACTIVE=TRUE.因为这二个方法只支持SQL中的SELECT语句!