Subject | Re: [firebird-support] Unsupported parameter into SQL expression |
---|---|
Author | masotti |
Post date | 2009-04-29T07:43:34Z |
Codebue Fabio - P-Soft ha scritto:
SELECT ART_CODICE, QUANTITA, PREZZO, PREZZO / 100. 00 * CAST ( :sconto )
AS INTEGER
and this is the workaround.
Other with better knowledge in inner workings can explain better than me
why it's so.
Ciao.
Mimmo.
> When I try yo execute a statem like thisIt make sense, but try something like that
>
> select art_codice, QUANTITA, PREZZO,
> PREZZO / 100 * :sconto
> from mmr
>
SELECT ART_CODICE, QUANTITA, PREZZO, PREZZO / 100. 00 * CAST ( :sconto )
AS INTEGER
and this is the workaround.
Other with better knowledge in inner workings can explain better than me
why it's so.
Ciao.
Mimmo.