Subject | Problem With Firebird RC1 |
---|---|
Author | Marco Lauria |
Post date | 2001-11-23T11:50:28Z |
Hi I had this query in a SP
SELECT SUM(RV.ELEMENTI) AS QUANTITA, SUM(RV.TOTALE) AS TOTALEINCASSO,
F_STRIP_TIME( RV.DATA ) AS DATANOORA ,
RV.DATA, RV.REPARTO, M.ID_SET_MAGAZ, S.DESCR_SET_MAGAZ
FROM V_DOCUMENTI_RIGHE_VENDITA RV
LEFT JOIN MAGAZ M ON M.ID_MAGAZ = RV.ID_MAGAZ
LEFT JOIN SET_MAGAZ S ON S.ID_SET_MAGAZ = M.ID_SET_MAGAZ
WHERE RV.CASSA = :NumeroCassa AND RV.DATA >= :DataIniziale
AND RV.DATA <= :DataFinale
GROUP BY RV.DATA, RV.REPARTO, M.ID_SET_MAGAZ, S.DESCR_SET_MAGAZ
ORDER BY RV.DATA, S.DESCR_SET_MAGAZ
that compiled correctly under the latest beta release.
Now I upgraded to FB 1.0 RC1
And I get an "INVALID COLUMN REFERENCE"
If I delete the F_STRIP_TIME( RV.DATA ) AS DATANOORA everything
works correctly,
but I need it....
how can I avoid this?
Regards
Marco Lauria
STARMAX s.a.s.
SELECT SUM(RV.ELEMENTI) AS QUANTITA, SUM(RV.TOTALE) AS TOTALEINCASSO,
F_STRIP_TIME( RV.DATA ) AS DATANOORA ,
RV.DATA, RV.REPARTO, M.ID_SET_MAGAZ, S.DESCR_SET_MAGAZ
FROM V_DOCUMENTI_RIGHE_VENDITA RV
LEFT JOIN MAGAZ M ON M.ID_MAGAZ = RV.ID_MAGAZ
LEFT JOIN SET_MAGAZ S ON S.ID_SET_MAGAZ = M.ID_SET_MAGAZ
WHERE RV.CASSA = :NumeroCassa AND RV.DATA >= :DataIniziale
AND RV.DATA <= :DataFinale
GROUP BY RV.DATA, RV.REPARTO, M.ID_SET_MAGAZ, S.DESCR_SET_MAGAZ
ORDER BY RV.DATA, S.DESCR_SET_MAGAZ
that compiled correctly under the latest beta release.
Now I upgraded to FB 1.0 RC1
And I get an "INVALID COLUMN REFERENCE"
If I delete the F_STRIP_TIME( RV.DATA ) AS DATANOORA everything
works correctly,
but I need it....
how can I avoid this?
Regards
Marco Lauria
STARMAX s.a.s.