>Prior to VFP 9 this worked fine. I am finding now that the record pointer in the scvndino table is not on the correct record anymore in the method. If the select statement is going through a hundred records this method returns the results for the first record in the table all 100 times.
>
>Sending vin_duedate as a parameter to the method and replacing "vin_duedate" with this parameter DOES work. My concern is that I have code like this all over the place. Is there something else I'm missing?
>

Hi Paul,

If it worked, it worked by accident. Regardless how table is named and what alias is assigned to it in the FROM clause, the workarea alias that will be assigned by VFP to the table during the query evaluation is not defined. Therefore, the function called from a SQL statement should not make any assumptions about the alias.

Thanks,
Aleksey.