> One thing that seems to pop out at me, how is the ordering of the

rows

> managed with FIBPlus, if the original Select has been executed and
> thereafter you insert and update rows, that would affect the sort
> order of the result set. The only answer that I can think of is that
> there's some sorting performed in the buffer on the client, and that
> any additional rows fetched from the server will have to be sorted

by

> the client.

And how is this taken care in IBO?

> My preferred way is to have one read-only TIB_Query(or TIBOQuery)
> attached to a read-only transaction for viewing data in a grid and
> searching. And, then use a read/write TIB_Query(or TIBOQuery)

attached

> to a read-write transaction for editing the selected row in a popup
> form.

And how do you see the result in the read-only TIB_Query? Do you call
TIB_Query.Refresh after you make changes to the read-write query? If
you could avoid somehow to refetch all the rows and only fetch the
rows added to the read-write query, that would be great.