Subject Re: [firebird-support] Unsupported parameter into SQL expression
Author Helen Borrie
At 05:18 PM 29/04/2009, you wrote:
>When I try yo execute a statem like this
>
>select art_codice, QUANTITA, PREZZO,
>PREZZO / 100 * :sconto
>from mmr
>
>I receive an error:
>
>Dynamic SQL Error expression evaluation not supported

Provide an expression that *can* be evaluated, e.g.,

select art_codice, QUANTITA, PREZZO,
PREZZO / 100 * (cast (:sconto as integer)) as result
from mmr

./hb