The way you accomplish this is use the FOR UPDATE clause with your select
statement. This tells the engine to only send a single record at a time from
the server. Otherwise, by default, it will pull in enough records to fill a
network packet so that more efficient use of your bandwidth.

Be sure to watch in the SQL trace monitor to see if that clause remains. I
suggest only using the TIB_Cursor component for these queries because it is
unidirectional and not buffered.

HTH,
Jason Wharton

----- Original Message -----
From: "Aurimas Černius" <aurimas@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, May 28, 2009 1:11 AM
Subject: [IBO] Fetch rows one by one


> Hello,
>
> I have a procedure, which does a long lasting updates (about 1 hour
> total). In order to see the progress, procedure suspends rows between
> separate update statements.
> AFAIK, if I don't use any "order by", just a dummy "select * from proc",
> I should be able to get get first few rows before the completion of
> procedure execution.
> How can I do this with IBO? It seems, that it fetches a certain about of
> records, so I need to wait until procedure suspends them. How can I
> fetch records one at a time?
>
> --
> Aurimas