Marco,

Ok, I need you to send me (again if necessary) a DDL script to create the
database so that I can test this query. I cannot seem to get it to do this
very strange "(." prefix thing.

As for the grid thing, that issue is with someone else. Sorry for crossing
a wire there.

Regards,
Jason

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Marco Menardi
> Sent: Wednesday, November 22, 2006 11:48 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Re: 4.7 Beta3 in the Trustware repository
>
>
> --- In IBObjects@yahoogroups.com, "Jason Wharton"
> <supportlist@...> wrote:
> >
> > Marco Menardi wrote:
> > > There are still problems in the parse of the fields
> aliases (reported
> > > to you with a private message), so FastReport does not work as
> > > expected (can't test with IB_SQL b3 since you have not
> yet provided).
> >
> > Please get the last 4.7 Beta4 and test with FastReport. It should
> be fine
> > now.
>
> No, it's NOT :(
> In IBO_SQL 4.7.Beta4 this query:
> SELECT
> OUT_CONTO_ID AS SOTTOCONTO_ID,
> OUT_DESCRIZIONEDISP AS SOTTOCONTO_DESC,
> OUT_SALDO AS SOTTOCONTO_SALDO,
> LK_CONTO_MOVCON_DETT_CONS.OUT_MOVCON AS STAMPA_MOVIMENTI
> FROM GET_SOTTOCONTI_COMPARTO_MC (
> '000000',
> 'FALO',
> 'RI0001',
> 'S',
> '')
> LEFT JOIN LK_CONTO_MOVCON_DETT_CONS(OUT_CONTO_ID, 'FALO',
> '000000', 'S')
> ON (1=1)
> WHERE ((GET_SOTTOCONTI_COMPARTO_MC.OUT_SALDO <> 0) OR
> ((LK_CONTO_MOVCON_DETT_CONS.OUT_MOVCON = 'S') AND
> (GET_SOTTOCONTI_COMPARTO_MC.OUT_MC_TROVATI = 'S'))
> )
> ORDER BY 1
>
> still returns as field names ( [FieldName "subtablet" in the cursor
> window)
> (.OUT_CONTO_ID
> (.OUT_DESCRIZIONEDISP
> (.OUT_SALDO
> LK_CONTO_MOVCON_DETT_CONS.OUT_MOVCON
>
> (as you see, there are mysterious heading "(." where aliases are used)
> Also, of course, FastReport does not work (can't find the fields names
> I've specified for the report)