>>
>>In FPW, you can build a filtered index that contains a UDF. If the nature of the filter condition requires that a UDF be used, this is one alternative. Another might be using a query to retrieve the record set. Of course, under VFP, I would hestitate to use either.
>
>It's sloppy but the UDF could return a character string to complete the SET FILTER TO; ie:
>
>cFilter=MyFunc()
>SET FILTER TO &cFilter
Yeah, you could do that, but I think it's more self-documenting just to assign the string. The only exception would be if the function was used elsewheres.
>But my response would match yours --- yuck.
BTW, what I meant in the previous post was that I'd use an updatable view, rather than a filter or a filtered index. Geez, I'm getting sloppy.:-)
George
Ubi caritas et amor, deus ibi est