Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with DATETIME field in index
Message
De
09/01/2000 20:02:11
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00315277
Message ID:
00315289
Vues:
27
>>I have a "log" table with an index on Date Time. The index is working find, until I deleted some of the entries
>>and packed the file. The index does not seem to work now. I restored the table and simply redinexed and
>>the index is not working.
>>
>>Any ideas????
>
>Norm,
>
>What does "index is not working" mean?

If I use the following commands
     workdate = sclhist.datetime
     count for sclhist.datetime = workdate
The count returns zero. If I do the same thing with the "restored" table (before the reindex) the count returns 1277.
I have checked and all 1277 of the data records are present.
____________________________________________

Norm Peterson

It's a dog eat dog world out there,
and I'm wear'n milk bone underware!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform