On a win98 machine running VFP6, I am getting results on a date field in this sql out of order:
sele date from timehist grou by date (Date = a date field)
settings:
set cent on
set stri to 0
(I even made the time/date format MM/dd/yyyy in the control panel)
The table has index, but isn't currently ordered, and I tried reindexing.
Yet, when I try this on my win2000 machine with the same settings on a table of the same structure, the results are ordered. Both machines have the service pack 2 update.
Most of the records are in order but I'll see this:
04/09/2002
04/11/2002
04/08/2002
04/12/2002
04/10/2002
Has anyone seen this?
sele date from timehist grou by date (Date = a date field)
settings:
set cent on
set stri to 0
(I even made the time/date format MM/dd/yyyy in the control panel)
The table has index, but isn't currently ordered, and I tried reindexing.
Yet, when I try this on my win2000 machine with the same settings on a table of the same structure, the results are ordered. Both machines have the service pack 2 update.
Most of the records are in order but I'll see this:
04/09/2002
04/11/2002
04/08/2002
04/12/2002
04/10/2002
Has anyone seen this?