Subject Re: [firebird-support] Unsupported parameter into SQL expression
Author masotti
Codebue Fabio - P-Soft ha scritto:
> When I try yo execute a statem like this
>
> select art_codice, QUANTITA, PREZZO,
> PREZZO / 100 * :sconto
> from mmr
>
It make sense, but try something like that

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.