Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using datetime index and using with a seek command?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00612987
Message ID:
00613038
Vues:
13
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform