Hi,
I have a UDF funtion which will be called in my SQL statement - WHERE clause. I need ot pass a variable by reference to this UDF funcion. However, it doesn't work. The variable doesn't passed by reference (I try to change the value in UDF function by the value reset on next call). It works if i call it from HAVING clause. Any ideas?
Thank you
SELECT * FROM csrInvoice ;
WHERE THIS.Include(Qty, StockQty, @lnCount, @lnSum) ;
INTO CURSOR csrInvoice
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...