Subject Re: [IBO] SQL Query problem?
Author Jason Wharton
I think I have a file missing in my patch file somehow. When users
contribute changes I sometimes forget to touch the timestamp so that it gets
picked up in my patch file.

As for IB_Events, I have made a couple changes. I didn't test it with CPPB.
I'll give this a look. I forgot the limitation of CPPB on properties using
an Array. Go ahead and just make it a direct variable reference if you like.
That's what I will do to fix it since it is a protected member.

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: Thursday, October 03, 2002 6:17 AM
Subject: Re: [IBO] SQL Query problem?


> Dear Jason,
> I've tried yesturday version v. 4.02hl and today 4.02hm, but, compiling
with
> CBUILDER5, where there is the IB_EVENTS.PAS I always got the following
> error:
>
> [Pascal Error] IB_Events.pas(860): Unsupported language feature: 'property
> of array type'
>
> For a try, I used the old IB_Events.pas all works fine and I built all
the
> packages.
> In reality, in the design time, I cannot open IB_Query object on the
form
> with the double click because I got an error too.
>
> Could be some incompatibility on the new IB_Events.pas?
>
> Thank You!
>
>
>
> ----- Original Message -----
> From: "Jason Wharton" <jwharton@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Tuesday, October 01, 2002 9:22 PM
> Subject: Re: [IBO] SQL Query problem?
>
>
> > 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.