Subject | Re: [firebird-support] Unsupported parameter into SQL expression |
---|---|
Author | Helen Borrie |
Post date | 2009-04-29T07:48:39Z |
At 05:18 PM 29/04/2009, you wrote:
select art_codice, QUANTITA, PREZZO,
PREZZO / 100 * (cast (:sconto as integer)) as result
from mmr
./hb
>When I try yo execute a statem like thisProvide an expression that *can* be evaluated, e.g.,
>
>select art_codice, QUANTITA, PREZZO,
>PREZZO / 100 * :sconto
>from mmr
>
>I receive an error:
>
>Dynamic SQL Error expression evaluation not supported
select art_codice, QUANTITA, PREZZO,
PREZZO / 100 * (cast (:sconto as integer)) as result
from mmr
./hb