sounds very weird, shouldn't be caused by ODBC, here are some suggestions, try to build your sql one step at a time to see if they make any differences1. select * from table1 where f1='0'2. select * from table1 where f1='0' and year(f2)=2003 3. select * from table1 where f1='0' and year(f2)=2003 and month(f3)=12 4. ....
select * from table1 where f1='0'2.
select * from table1 where f1='0' and year(f2)=2003 3.
select * from table1 where f1='0' and year(f2)=2003 and month(f3)=12 4.
....
明天再讨论吧,我得回家了,呵呵,有心的帮我UP好么?一起找BUG