General information
Category:
Coding, syntax & commands
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only