Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INDEX ON DateTime Field?
Message
De
27/10/1998 10:55:08
 
 
À
27/10/1998 10:40:16
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00150884
Message ID:
00150995
Vues:
16
>>I am having trouble get the proper return results
>>when using an index tag on a datetime field. Try
>>this and you will see what I mean
>>
>>CREATE CURSOR c_tbl (dt_tm T)
>>INSERT INTO c_tbl (dt_tm) VALUES ({10/27/1998 08:30:00 AM})
>>INSERT INTO c_tbl (dt_tm) VALUES ({10/27/1998 08:31:00 AM})
>>INDEX ON dt_tm TAG dt_tm
>>SELECT * FROM c_tbl WHERE dt_tm = {10/27/1998 08:30:00 AM}
>>
>>?_TALLY && returns nothing
>>
>>SELECT c_tbl
>>DELETE TAG dt_tm
>>SELECT * FROM c_tbl WHERE dt_tm = {10/27/1998 08:30:00 AM}
>>?_tally && returns 1
>>
>>Why am I getting inconsistent results?
>Tom,
>_tally is not a trustable system variable at all times. Explicitly check reccount() or alen().
>Cetin

Cetin, I would agree that _TALLY is not the best method. I was
merely trying to convey the point that the results are not what
I would expect. RECCOUNT() and a visual examination of the results
show that _TALLY returned the correct results as presented above.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform