Subject Re: Error when using Query with RelAliases, and a join, in a IB_LookupCombo
Author Marco Menardi
--- In IBObjects@yahoogroups.com, "Adrian Wreyford" <wreymed@...> wrote:
>
> Hi Jason,
>
>
>
> Please see the Test Project I uploaded for the example ie
TestError2.zip I
> used IBO4.7_Beta1 and FB2.0
>
>
>
> After you have selected the Record in the LookupCombo, and then move
on to
> the next field, the lookupcombo looses its record.
>
>
> Adrian

Don't know if is related, but with IBO4.7_Beta2 and FB 1.5.x or 2.0,
at least my FastReport seems to get fields name ignoring aliases.
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 (
:P_ESERCIZIO_ID,
:P_CONDOMINIO_ID,
:P_CONTO_ID,
'S',
:P_COMPARTO_MC_ID)
LEFT JOIN LK_CONTO_MOVCON_DETT_CONS(OUT_CONTO_ID, :P_CONDOMINIO_ID,
:P_ESERCIZIO_ID, :P_FORZA_STAMPA_MOVCON) 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

with IBO 4.5 resulted in:
SOTTOCONTO_ID
SOTTOCONTO_DESC
SOTTOCONTO_SALDO
STAMPA_MOVIMENTI

now in:
OUT_CONTO_ID
OUT_DESCRIZIONEDISP
OUT_SALDO
LK_CONTO_MOVCON_DETT_CONS.OUT_MOVCON

so then the report crashes because can't find the fields.
Looking forward for a IBO4.7_Beta3 to do more test before final release.
regards
Marco Menardi