>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
>
>

John,
Since that doesn't work, why not simply not pass the variables and use private variables set up before the SQL statement. If the variables are private in scope they are visible to the function called in the SQL statement.

HTH.