Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index on Datetime column?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Contrats & ententes
Divers
Thread ID:
00469678
Message ID:
00469804
Vues:
18
Steve,

One of the reasons for using the TTOC() is the following. VFP stores DateTime data to the millisecond in the DBF but we only have access to the second. If we were to SEEK a DateTime value of say {^2001-01-01 12:00:00} we may fail to get a hit even if there is a record that "appears" to have that value. Why? Because our value has milliseconds of 0 while the field may have milliseconds of 1 thus NO HIT.

If the purpose of your index is simply to arrange records in an order, or if you only do searching in the index based on a range then this reason is meaningless to you.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform