Okay, I'll try to set something up.

Jason Wharton wrote:

> This does not sound correct.
>
> I would love to have a look at a sample app that demonstrates this problem.
>
> Jason Wharton
>
>
>> -----Original Message-----
>> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
>> Behalf Of Tom
>> Sent: Tuesday, November 07, 2006 6:06 AM
>> To: IBObjects@yahoogroups.com
>> Subject: Re: [IBO] View and Table direct update?
>>
>>
>> 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
>>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>