是/否字段就是Boolean类型,是=-1,否=0,因此你的SQL语句应该是: Select * From Table WHere Clear=0
to firechun(天火) help me http://www.csdn.net/expert/topic/366/366254.shtm
select * from table where [clear] =false
用true,false或-1,0都可以。下列语句都是对的: select * from table where clear =false select * from table where clear =0 select * from table where [clear] =false不信你可以在ACCESS中创建查询试一下。 你的错误在别的地方,不在查询语句本身
select * from table where clear =no access 2000 + dao3.6 可以
Select * From Table WHere Clear=0
help me
http://www.csdn.net/expert/topic/366/366254.shtm
select * from table where clear =false
select * from table where clear =0
select * from table where [clear] =false不信你可以在ACCESS中创建查询试一下。
你的错误在别的地方,不在查询语句本身
access 2000 + dao3.6 可以