do Adoquery1 with close; sql.clear; sql.add('insert into TableName (datetime) with (now()); open end; ----------------------------------------------- do Adoquery1 with close; sql.clear; sql.add('select * from Tablename where datetime>'1999-05-08' and datetime<2005-05-08') open end;
sql.add('insert into TableName (datetime) with (now()); 要插入几个参数怎么写呀 insert into tablename ('field1','field2') vaule( ? , )
插入参数这样写,假设a,b是参数名 adoquery.sql.add('insert into table (field1,field2)values(:a,:b) '); adoquery.parameters.parambyname('a').value:=edit1.text; adoquery.parameters.parambyname('b').value:=edit2.text;
adoquery.fieldbyname('字段名').asdatetime := now;
sqlserver:
adoquery.fieldbyname('字段名').asdatetime := date;
close;
sql.clear;
sql.add('insert into TableName (datetime) with (now());
open
end;
-----------------------------------------------
do Adoquery1 with
close;
sql.clear;
sql.add('select * from Tablename where datetime>'1999-05-08' and datetime<2005-05-08')
open
end;
要插入几个参数怎么写呀
insert into tablename ('field1','field2') vaule( ? , )
adoquery.sql.add('insert into table (field1,field2)values(:a,:b) ');
adoquery.parameters.parambyname('a').value:=edit1.text;
adoquery.parameters.parambyname('b').value:=edit2.text;