Subject sql true statement From Charlie <tm@tc.com> Date Mon, 25 May 2020 17:10:14 -0400 Newsgroups dbase.getting-started Hi..  I am having trouble with this sql statement: this.MASTER1 = new QUERY(this)    with (this.MASTER1)       left = -58.0       top = 13.0       database = form.database1       sql = 'select * from "master" where lchoo = "true"'    endwith and the on the onopen: cnt = 0                 cnt = form.master1.rowset.count()                 form.entryfield13.value = cnt Entryfield13 comes up with 0 and I've tried many variations.  It should come up with a larger number.  When I filter in command it does.   I have a feeling this is something stupid I'm doing but possibly it is because lchoo is a logical field. Thanks for any help.