>>>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.
You mean _tally was true ? This routine returning correct record sets despite _tally returning 0 and 1 on my system. So I would suspect it's related with datetime settings in tools\options. I don't remember well but one of the settings in control panel (regional) + set sysformats on in tools\options\regional were showing interesting results with date and datetime operations.
Cetin