hi, i have some problem with expression. Firebird was view error like this :
"Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
Dynamic SQL Error.
expression evaluation not supported"
this is my sql syntax :
"SELECT
bt.kodeBatch,
bt.kFrom,
br.kodebrg,
br.namabrg,
br.satuan,
(br.satuan-br.satuan) as bQty
FROM tbbatch bt INNER JOIN tbbarang br
ON substring(bt.kFrom from 1 for 12) = br.kodebrg
WHERE bt.kodebatch = :noBatch
INTO :kodeBatch,:KodeFrom,:kodeBarang,:NamaBarang,
:Satuan,:Qty;"
can u help me?


-thank-

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]