with query do begin close; sql.clear; sql.add('select * from table order by field1,field2'); open; end; while not query.eof do begin //dosomething; next; end;
with query do begin close; sql.clear; sql.add('select * from table order by field1,field2'); open; end; if not query.IsEmpty then begin query.First; while not query.eof do begin // dosomething; query.next; end; end;
begin
close;
sql.clear;
sql.add('select * from table order by field1,field2');
open;
end;
while not query.eof do
begin
//dosomething;
next;
end;
begin
close;
sql.clear;
sql.add('select * from table order by field1,field2');
open;
end;
if not query.IsEmpty then
begin
query.First;
while not query.eof do
begin
// dosomething;
query.next;
end;
end;