Tquery控件问题。

[chenqun]

Tquery控件可已往数据库里写数据吗，如能因如和写？

[hongqi162]

with query1 do
close;
sql.clear;
sql.add('select * from tablename');
open;
append;
fieldbyname('fda').asstring:='fdsa';
.....................................
post;

[IORILI]

query1.sql.add('insert xx values()');
query1.ExecSQL;
或update语句

[IORILI]

insert into table

[hiflower]

SQL：
with Query1 do
begin
Close;
SQL.Add('INSERT INTO tablename(field1,field2) VALUES(Data1,Data2)');
ExecSQL;
end;
不用 SQL：
with Query1 do
begin
Open;
Append;
FieldValues['Field1']:=Data1;
FieldValues['Field1']:=Data2;
Post;
end;