I am using VFP9 and I do a SELECT * FROM mytable WHERE thedate >
DATE(2007, 5, 1)
and it selects the correct records, but changes the dates in the result
cursor to garbage. I have been doing quite a bit with dates on this
project and any time I use a WHERE clause or SET FILTER TO or IF thedate
< ldsomedate, the dates get garbled. When I remove the filter or
selection it gives me the same result set, but the dates in the result
are correct.
This is very puzzling to me.
Jeff
Jeff Johnson
jeff /AT/ san-dc DO.T com
©2007 Jeff Johnson |
