Tom ---

I couldn't get the code to work under VFP5.0 and retain a DateTime index. However, the following code worked in VFP6. The problem has to be some sort of datatime ambiguity:

CREATE CURSOR c_tbl (dt_tm T)
INSERT INTO c_tbl (dt_tm) VALUES ({^1998/10/27 08:30:00 A})
INSERT INTO c_tbl (dt_tm) VALUES ({^1998/10/27 08:31:00 A})
INDEX ON dt_tm TAG dt_tm
SELECT * FROM c_tbl WHERE dt_tm = {^1998/10/27 08:30:00 A}


>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?