delete from table1 where name='' or company='' or name is NUll or company is Null
var i:integer; begin with query do begin if active then close; sql.clear; sql.add('select * from XX.db'); sql.add('where name=""'); open; for i:=1 to recordcount do begin delete; end; next; end; with query do begin close; end; end; OK
where name='' or company='' or name is NUll or company is Null
begin
with query do
begin
if active then close;
sql.clear;
sql.add('select * from XX.db');
sql.add('where name=""');
open;
for i:=1 to recordcount do
begin
delete;
end;
next;
end;
with query do
begin
close;
end;
end;
OK