Subject Re: FALSE or <> or not From Ken Mayer <dbase@nospam.goldenstag.net> Date Thu, 31 Dec 2020 05:48:08 -0800 Newsgroups dbase.getting-started On 12/30/2020 9:39 PM, Akshat Kapoor wrote: > 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. Yes but the logic often still works the same. Ken -- *Ken Mayer* Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm