|Subject||Re: support for 2 transactions in ib_query|
> One thing that seems to pop out at me, how is the ordering of therows
> managed with FIBPlus, if the original Select has been executed andby
> 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
> 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 popupAnd 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.