I believe this problem was the same one Daniel had pointed out that should
now be fixed.

I will release a new sub-release here in just a few minutes. Please test it
and let me know.

Thanks,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Enrico Cima" <enricima@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, September 25, 2002 2:39 AM
Subject: [IBO] SQL Query problem?


> Dear List,
> I've changed from Version 4.2Fr to 4.2Hj, but I've got the following
> problem:
>
> With "Fr" Version the following Query worked:
>
> SELECT
> N_COLORE,
> N_CODICE,
> NOME,
> CODICE_FORNITORE,
> (SELECT COD_ABV FROM FORN_FILATO WHERE CODICE=BASE_COL.FORNITORE_ID) AS
> COD_ABV,
> (SELECT VALUTA FROM VALUTA_DB WHERE CODICE=(SELECT VALUTA FROM CAT_COSTI
> WHERE CODICE=BASE_COL.N_CODICE
> AND FORNITORE_ID=BASE_COL.FORNITORE_ID
> AND DESC_CAT_TINT_ID=BASE_COL.DESC_CAT_TINT_ID
> AND DATAI<=:D AND DATAF>=:D)) AS VALUTA,
> (SELECT PREZZO FROM CAT_COSTI
> WHERE CODICE=BASE_COL.N_CODICE
> AND FORNITORE_ID=BASE_COL.FORNITORE_ID
> AND DESC_CAT_TINT_ID=BASE_COL.DESC_CAT_TINT_ID
> AND DATAI<=:D AND DATAF>=:D) AS PREZZO
> FROM BASE_COL
> ORDER BY N_COLORE
>
> instead with version "Hj" I've got an Exeption Error also directly
preparing
> the statment from the IB_Query Editor.
>
> If i Cut a part of the query, (SELECT VALUTA..... or SELECT PREZZO....)
> The Query still works.
>
> What I'm doing wrong?
>
> Thanks For Your comments.
> Best Regards to all list.
>
> P.S.
> I'm using CBUILDER5 and IB 6.0.