Subject Re: TIB_Query.next consume memory?
Author Aage Johansen
anfisoft wrote:
>
> My really huge Query-result is about 130.000 records big. I have to
> look at each of the records for some reason and coded:
>
> with IB_Query1 do
> begin
> open;
> first;
> while not(eof) do
> begin
> // here some outcommented code
> next;
> end;
> close;
> end;
>


I think your 'open' is redundant - 'first' is sufficient.
And, as Thomas noted, a TIB_Cursor is better for this.

--
Aage J.