Subject Re: [IBO] TIB_Grid update
Author steve_carter_ben
Thanks, Helen.
I had not included a TIB_Transaction component and so I was using the
default transaction, I guess. Once I added a TIB_Transaction component
and hooked my TIB_Query up to it, the grid refreshed as desired.

Steve

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 11:02 AM 24/08/2006, you wrote:
> >I've searched this group and found some messages about this, but they
> >addressed different issues than what I'm seeing.
> >
> >I have a TIB_Grid connected to a TIB_Query. I'm using the grid as a
> >picklist in a desktop application. The TIB_Query returns all rows from
> >a table of songs. I also have a TIB_Inc_Search component with the
> >datasource set to the datasource for the TIB_Query (I don't know if
> >this makes any difference). The user can enter a new song using a form
> >that calls a stored procedure to insert a record. I then call Refresh
> >on the TIB_Query, but the grid does not refresh. I've confirmed that
> >the record has abeen inserted. If I close the application and reopen,
> >the new tune is in the TIB_Grid.
> >
> >I've tried Close and then Open on the TIB_Query, as well as refresh.
> >
> >All the TIB_ components use the same TIB_Connection object.
> >
> >What am I missing?
>
> Transaction settings? It sounds as though you might be using a
> different transaction for the insert than for the select. Do the
> whole thing in a single transaction and commit the transaction before
> you refresh the grid's query.
>
> Helen
>