>Nadya,
>
>Hi. Thanks for helping me hit the books and that solved my problem.
>
>I double-checked Programmer's Language Ref Manual under TTOC() and added
>",1" to the TTOC command such as TTOC(mytable.mydate,1) and then the seek on the index worked. I also had to go into the index of the table and modify it the same way.
>
>I understand it is not a good idea to use ALLT() in an index expression. Why is it not a good idea to use ALLT() in an index expression? I think someone told me that before, but I don't think it ever caused me a problem. I can remove it and see what happens when I do a seek.
I believe, there were several discussions here in a past, which explained, why. I can search and find these messages for you. In my applications I always avoid alltrim as part of the index. We have alltrim in index expressions in other applications and they work fine, so I can not really suggest you to change it, if it's too late. However, if you just start developing this application, I would better avoid it.
If it's not broken, fix it until it is.
My Blog