Try to use
BufferSynchroFlags property of DataSet
set bsAfterEdit and bsAfterInsert to True.

Or you can set checboxes "Sync After Edit" and "Sync AfterInsert" in
the "UpdateSQL" TabSheet of Query edit-form.

--
Best regards,
Ramil khabibr@...

>
>
>
>
>
> Well, the question is:
>
> Is it normal that when inserting a new record in a view, where one
> of the values you add is a key used in the view, that the fields in
> the grid are not refreshed directly but only after moving
> back/forward in the grid?
>
> eg assume
>
> Table X
> ID Description
>
> Table Y
> ID X_ID Fee:
>
> Table Z:
> ID Y_ID
>
> View A:
> select Y.ID, Y.X_ID, X.Description, Y.Fee
> from Y
> left join X on Y.X_ID = X.ID
>
> View B:
> select Z.ID, Z.Y_ID, A.Description, A.Fee
> from Z
> left join A on Z.Y_ID=A.ID
>
> In the grid (showing contents of the view), you insert a new record
> and you fill in a value for Y_ID. When you post shouldn't the grid
> show the values of A.Description and A.Fee ?
>
> In my case these values stay empty until I move forward/backward in
> the grid.
>
> Thanks
> --- In IBObjects@yahoogroups.com, "Jason Wharton" <supportlist@...>
> wrote:
>>
>> I read this twice and I didn't get a clear understanding of the
> problem.
>> Could be that it's just Monday morning, but if you would please,
> expand on
>> this a bit.
>>
>> Thanks,
>> Jason
>>
>> > -----Original Message-----
>> > From: IBObjects@yahoogroups.com
> [mailto:IBObjects@yahoogroups.com]On
>> > Behalf Of Tom
>> > Sent: Sunday, November 05, 2006 3:34 AM
>> > To: IBObjects@yahoogroups.com
>> > Subject: [IBO] View and Table direct update?
>> >
>> >
>> > Hi,
>> >
>> > I've a TIBOTable which is feeded by a view (v), the view itself
> is a
>> > join over a database-table (a) and another view (b).
>> >
>> > This table is connected with a mastersouce table.
>> >
>> > A grid is connected to this detailtable through a datasource. The
>> > grid displays two values (from b).
>> >
>> > When I add a line in a grid (connected to a datasource to the
>> > detailtable). I can provide a value to a field, but when I press
>> > enter, the grid does not shows the corresponding value of the
> second
>> > field. When I move back and forward in the master grid, the
> detail
>> > grid shows both values correctly. So I guess the grid or table
>> > doesn't refresh itself immediatelly after the insert...
>> >
>> > Is this normal behavior? Can I do something about it?
>> >
>> > Thanks
>>