Subject Re: [IBO] Difference 'tween Open & First (IB_Cursor)
Author Ryan Nilsson-Harding
Thank you both Helen & Geoff.

I have a much better understanding now.
It may be your suggested case, Geoff, that the AutoFetchFirst is not
working. Not a problem now though, as I'm using First everywhere.

Thanks again.

--- In IBObjects@y..., Geoff Worboys <geoff@t...> wrote:
> > The other thing to remember (and why Open is redundant in an
> > ib_cursor) is that, because there is no client-side buffer, Open
> > positions the cursor at BOF, not on the first row. Until you
> > First, you are effectively "nowhere". First causes the ib_cursor
> > to fetch the first eligible record, Next the next and so on.
> There is an AutoFetchFirst property on TIB_Cursor (part of the base
> TIB_Dataset class). It defaults to True. So unless this feature
> is not working it the cursor should (by default) proceed to the
> first record when it is opened. Perhaps it is possible that this
> feature is not working properly with an Open after a Close without
> and unprepare.
> --
> Geoff Worboys
> Telesis Computing