On 30-3-2013 18:28, Ann Harrison wrote:

> The exact problem is one where not all the records are retrieved for a
>> particular cursor, a scroll cursor. Every now and again it retrieves 49
>> rows when it should retrieve 50. It happens about twice a day when under
>> load, which is not a lot as 10,000s, of records are read and updated daily,
>> but unfortunately it has a ripple effect in the rest of the application
>> when this happens.
>
> Hmm... That's interesting and odd, but scrolling cursors are after my day,
> so I'll let someone else answer that.

Firebird doesn't have scrollable cursor, that is to be introduced in
Firebird 3; all existing scrollable cursors are clientside.

Mark
--
Mark Rotteveel