You need to use both FOR UPDATE and the TIB_Cursor component to have the
server only send one record at a time.

Jason Wharton

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


> Hello,
>
>> 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.
>
> Just adding FOR UPDATE didn't help. I haven't looked more on the "why",
> because TIB_Cursor just did the job.
> Thank you for your help.
>
> --
> Aurimas
>
>