Subject Re: support for 2 transactions in ib_query
Author gsmcq
> One thing that seems to pop out at me, how is the ordering of the
> 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
> 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)
> 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.