| Subject | Re: filter on logical plus date field |
| From | Rouke <moc.liamg@rekkabrg> |
| Date | Thu, 06 Jan 2022 14:27:38 -0500 |
| Newsgroups | dbase.getting-started |
Thanks, set filter to not (returned=true or not isblank(dateofrtrn)) seems to give the required result. Any idea how to do this in local sql? Where NOT (loans.RETURNED = True OR NOT isblank(loans.DATEOFRTRN)) doesn't get accepted. Thanks, Roiuke Heinz Kesting Wrote: > Hi Rouke, > > > In a table with a logical field 'returned' and a date field 'dateofrtrn' I'm getting weird results when I set a filter to not returned or isblank(dateofrtrn). I expect to see no records with a tick in the 'returned' field and also to see no records other than a blank value in the dateofrtrn field. However, I get the following (eg. of three records): > > > > set filt to not returned or isblank(dateofrtrn) > > > > list returned, dateofrtrn for recno()=2 or recno()=3 or recno()=14 > > > > Record# returned dateofrtrn > > 2 .F. / / > > 3 .F. 22/12/2013 > > 14 .T. / / > > > > I expect only records like 2. Why are records 3 and 14 listed? > > > My 2 cents: > > set filt to not returned AND isblank(dateofrtrn) > > with the OR condition record#3 would meet the filter. > > Hope this helps > > Kind regards, Heinz | |