Hello !!!

I didn't read the other messages but the solution of Lester:

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

I think, also is possibly with this other SELECT:

SELECT cu.customer, ag.desagente, tt.type
FROM customer cu, agent ag,type tt
WHERE
ag.agent_code=cu.agent and
cu.type=tt.type_code

I don't know which is better, you have to test it.

Bye,

--- In IBObjects@y..., lester@l... wrote:
> 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