I'll try and send this again - I think my son has been
'playing' - all my eMail from last night has been marked as
Fwd: = not sure what he did, he's not up yet <g>

> In the application that manage the customer table, every field is
> associated
> with a my personal component and every time I locate a customer in the
> table, the component in automatic refresh the description of every
> associated
> field (for ex. the name of the agent) (the table can have 20/30 field to
> decode).
> To all that components I associate ever the same TIBOQuery, that
> have no persistent fields, and every type of components set the
> TIBOQuery
> Sql statement as its need (ex. in order to decode the agent the select
> statement
> is SELECT DESAGENTE FROM AGENT_TABLE WHERE
> AGENT_CODE = 'XXX').
> (that statement can be very different, i not only decode the field but i
> use
> the TIBOQuery to find information about the validity of the field value
> and a lot of more funtionality)

I think you are making too much work for yourself.

The whole point of a relational databse is to work with this
sort of related data.

Have you tried making a query ( and it can be an IBOQuery !
) where the 'conversion' is included?

SELECT CU.CUSTOMER
, ( SELECT DESAGENTE FROM AGENT_TABLE WHERE AGENT_CODE
= CU.AGENT ) AS AGENT
, ( SELECT TYPE FROM TYPE_TABLE WHERE TYPE_CODE =
CU.TYPE ) AS TYPE
FROM CUSTOMER CU

This will fill in the descriptions automatically, and starts
to use some of the power of IBObjects.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services