>>Dear All,
>>
>>I am writing a SELECT statement. I have to use multiple UDFs in it as there are a lot of complicated calcuations going on in it and the return value from the UDF is to be used as the value for the SELECT.
>>
>>1) Should I, WHERE join the required DBFs and in the UDF straight away use the current record in the respective DBFs for calculations?
>
>
>I would try this first.

No Go. The record pointer is not where it should be for the record being joined in the DBFs

>
>>2) Should I, not join those DBFs (not required except for the calc anyway) and do SEEK() for the required DBFs in the UDFs
>
>
>I would try that if the first approach is too slow or there is no easy way to join tables.

I removed all the joined DBF just for this purpose and in my UDF is did my seeks and it works

Thanks Sergey