🚀 go-pugleaf

Bill Todd [TeamB] wrote:
> Your last post in this thread is:
> 
> "sql server has isnull() function but interbase did not has it , I
> really did not want to use alot of if to test for null I hope also not
> to us UDF!!"
> 
> which I understood to mean that you are looking for a way to do what
> ISNULL does in Transact SQL. In my reply I provided the alternatives
> that are available in IB. Now you are telling us that COALESCE gave you
> an error but you do not show us the code that caused the error. No one
> here can read your mind. If you want help you must provide enough
> information.
> 
I am crying here, always misunderstand me

here is my last post again:
update:
I get this error:

Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
Dynamic SQL Error.
expression evaluation not supported.


when I try to execute this SQL

select COALESCE(sum(QTY),0), COALESCE(sum(QTY * COST_PRICE),0) from 
purchase_inv_item
     left outer join purchase_inv on (purchase_inv_item.pur_code = 
purchase_inv.pur_code)
     where (purchase_inv.purch_return <> 1)
       and (PURCHASE_INV_ITEM.item_code = :p_new_item_code)
       and (PURCHASE_INV_ITEM.inv_code = :p_new_inv_code)
       into :pur_sum_qty, :pur_sum_cost;

I successfully compiled the procedure but I get the error at run time !!
I also tried to make like this sum(COALESCE(QTY,0)) but I was not able 
to even compile

please advice