> I have the follow select in my TIB_Query:
>
> SELECT CODE_ANIMAL,(SELECT LIST(R.NAME,',') FROM RACIAL_COMPOSITION INNER
> JOIN RACES R ON ID_RACE = RACIAL_COMPOSITION.FG_ID_RACE AND
> RACIAL_COMPOSITION.FG_ID_ANIMAL=ANIMALS.ID_ANIMALl) AS RACIAL_COMP
>
> I need to show the racial composition of the animals and when the racial
> composition has more than a race then the races must be separated by
> comma.
> But the content of the field does not appear, it appears only RACIAL_COMP.
>
> Anybody can help me ?

It doesn't appear where?

This will give you a blob column. Have you set auto load to true?

Not sure what else the problem could be.

Jason