Subject RE: [IBO] Re: consume memory?
Author John Tomaselli
If possible it would be beter to put this in a stored procedure.

-----Original Message-----
From: Aage Johansen [mailto:aagjohan@...]
Sent: Friday, September 27, 2002 4:53 PM
Subject: [IBO] Re: consume memory?

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.

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to