Subject Re: sql true statement From Charlie <tm@tc.com> Date Mon, 25 May 2020 17:45:25 -0400 Newsgroups dbase.getting-started OK I fixed it.  I was writing over an old sql which had become redundant.  I guess that isn't a smart idea.  I created a new sql and everything is peachy!!! Charlie Wrote: > 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.