>>Not quite a bug, but a peculiarity of foxpro:
>>if you set the index to seq_no, it first tries to find an index with the _name_ seq_no. If that does not exist it will evaluate seq_no. It will then try to set the index to the result of that expression, in this case the result seems to be 1, so it sets the index to 1
>>if seq_no evaluates to "k_memo" the index will be set to k_memo (if it exists)
>>So, if you use an index name, you better use order "seq_no", if you want is as an expression use (seq_no)
>
>I still think it's a bug. If I want VFP to evaliate the name I would use a name expression.
Sergey, although I understant the argument I agree with you. I just sent the bug report to MS. If I hear anything I let everyone know the result.
Thanks to everyone for their valuable input. At least we all know what is going on here.
John
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn