Information générale
Catégorie:
Codage, syntaxe et commandes
>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement