| Subject | Re: [firebird-support] Unsupported parameter into SQL expression |
|---|---|
| Author | masotti |
| Post date | 2009-04-29T07:57:12Z |
masotti ha scritto:
CAST ( :sconto AS INTEGER )
Obviously. And to clarify order of operator's precedence
( CAST ( :SCONTO as integer ) * PREZZO ) / 100.00
Ciao.
Mimmo.
> SELECT ART_CODICE, QUANTITA, PREZZO, PREZZO / 100. 00 * CAST ( :sconto )Well, not too much coffee this morning in finger: sigh.
> AS INTEGER
>
CAST ( :sconto AS INTEGER )
Obviously. And to clarify order of operator's precedence
( CAST ( :SCONTO as integer ) * PREZZO ) / 100.00
Ciao.
Mimmo.