I do not think it is too picky at all. I also do not think it is possible to think of all the crazy ways a developer would create an index expression. So, all I can do is try to give my best shot at stripping out just the field names. I do not think I could every support the use of a memvar in an expression. Those who use memvars in a PK are just asking for disaster.
>Mark,
>If that doesn't need to be very generic I think would do. Otherwise expressions might be tricky as well as operators to get a correct list of fields included in expression. ie:
>
>lastname-firstname
>
>iif(seek(SomeField,'sometable','sometag'),sometable.someotherfield,0)
>
>"Name"+lastname-(', '+firstname)
>
>dtoc(m.entrydate,1)+dtoc(exitdate,1) && name and entrydate fields exist
>
>etc. I know it'd be nonsense to build some of these expressions for an index but at the end despite warnings in doc VFP lets you to do so.
>PS: Is this called to 'picky' :)
>Cetin
Mark McCasland
Midlothian, TX USA