Subject Re: FALSE or <> or not From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Thu, 31 Dec 2020 11:09:48 +0530 Newsgroups dbase.getting-started Good Morning Rouke, > In dbase plus 8 with ADO I have a simple table with a few character, date, numeric fields and a logical field. The logical field (field name 'returned') is a tick box. I have double clicked some of the tick boxes and left some as they were. The double clicked tick boxes show a tick, the other ones don't. I assume the ones that do not show a tick are .F. or .N. and the ones that do show a tick are .T. or .Y.. If I 'set filter to returned', all records with ticked tick boxes show, when I 'set filter to not returned' only those records with unticked tick boxes show. But when I 'set filter to returned = .F.', a seemingly random and much smaller number (only 3) of records show, albeit with the tick boxes unticked. When I 'set filter to returned<>.T.', all records with an unticked tick box show. So I wonder, what's the difference between FALSE or <> or not? This is in addition to what Ken has written. Not all backend databases have logical as field types some store 1 for true and 0 for false also. Regards Akshat