thanks i miss, i have trigger before insert to uppercase custno this
make position fail.

--- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:
> > i am using ib_grid with ib_query, after insert one row cursor
still at
> > the position but after ib_query.refresh position change to random,
how
> > to handle the position? (query ex: select * from customer order by
> > custno).
> >
> > thanks for reply and help.
>
> set keylinks to PK field
> set genlinks to generator name
> set query RefreshAction to raKeepDataPos
>
> should work
> Alan