with query do
begin
close;
sql.clear;
sql.add('delete tablename where name=:value');
params[0].asstring := 'taxi';
execsql;
end;
begin
close;
sql.clear;
sql.add('delete tablename where name=:value');
params[0].asstring := 'taxi';
execsql;
end;
调试欢乐多
if active then close
sql.clear
sql.add('delete from tablename where condition')
execsql;
end;
如果query的sql是'select * from tablename...'
而且 query.open:=true;
直接用 query.delete 就可以删除指针当前所指的记录