Subject Re: [IBO] Seeing recently changed data
Author Helen Borrie
At 12:03 AM 19/10/2004 +0000, you wrote:


>I have a TIBOQuery(A) attached to a DevExpress Grid. Another TIBOQuery
>(B) points to the same data table as A.
>
>When I make changes to B, post and Commit them and refresh A they
>don't show up in my grid, even though my transaction isoloation is set
>to "tiCommited".
>
>However, the changes do show up after I close and reopen the
>application. What am I doing wrong?

You must refresh *both* datasets. Although they are queries on the same
table, they are two different statements. Each dataset looks after its own
set.

Tip: if you are using one control (B) for edits and your grid (A) for
selecting rows, you don't need two queries. You can use one query with one
datasource and point all of the controls at that datasource. Include all
of the fields you want for both [sets of] controls and set the
FieldsVisible property to false on any that you don't want to display in
the grid.

This way, you have only dataset to refresh.

Helen