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?

2) Should I, not join those DBFs (not required except for the calc anyway) and do SEEK() for the required DBFs in the UDFs

Please Help

Thanks in advance.