At 03:36 AM 22-03-02 -0300, you wrote:

>-----------------
>In the example of the Configuring ib_loockucombo, the field isn't in the
>table. Ex:
>select
> NAME,
> (select DESCRIPTION from PRODUCETYPE T
> where T.TYPE = P.TYPE) as TYPE_DESC,
> DESCRIPTION,
> PRICE,
> QTY
>from PRODUCE P
>
>Then is just so? Is not necessary to put the TYPE_DESC in any insertSQL or
>updateSQL..

No! Not only is it unnecessary, it is also impossible! It is a computed
field, and computed fields are not updatable. You should tell IBO this
fact, by setting its COMPUTED property to True.

To reiterate, you do not need insertSQL and updateSQL except in special
cases where it is not possible to treat a dataset as "updatable" -
typically where your data are selected from a joined or unioned dataset, or
a selectable stored procedure.

Your case appears to be perfectly standard - provided you include that
lookup key column modalidade_id in your dataset.

I will look at the example in the GSG - I should have included PRODUCT.TYPE
in that dataset....


regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com