with query1 do close; sql.clear; sql.add('select * from tablename'); open; append; fieldbyname('fda').asstring:='fdsa'; ..................................... post;
query1.sql.add('insert xx values()'); query1.ExecSQL; 或update语句
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;
close;
sql.clear;
sql.add('select * from tablename');
open;
append;
fieldbyname('fda').asstring:='fdsa';
.....................................
post;
query1.ExecSQL;
或update语句
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;