>did you know that you can create an index using your own functions. Example: index on MYFUNCTION(vfp_expression) tag mytag
>
>where MYFUNCTION is a function you create. Or did y'all already know this.
Dean,
Yes y9ou can do that. However, you cannot ever open that table if tyhe UDF is not visible to VFP as it will cuase an error that will prevent the table from opening. Also, you must insure that the UDF always returns a value of the same type and length or else the index will become corrupt.
This is one of those things that "can be done" but "shouldn't be done". Like shooting yourself in the head, of course you can shoot yourself, but it isn't a very good idea to do it.