>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