Subject Re: Filter From Mattia <mattia@nospam.com> Date Tue, 14 Dec 2021 05:00:17 -0500 Newsgroups dbase.getting-started I don't know if it is possbile for you but to avoid these problems with empty or null fields you could set betj_n to 'N' when you create the record in your DBF and then set a filter with BETJ_N = 'N' Bye Mattia AGOSTINHO  Wrote: > Very strange behavior > When trying from the command box  "SET FILTER TO BETJ_N <> 'J' then when browsing I get only records with the  betj_n " " (empty) non paid records > but when applying this to the rowset property I don't get any records on the grid. > What can be wrong here? >   > Mervyn Bick Wrote: > > > On 2021/12/13 20:29, Agostinho wrote: > > > Dear Mervyn thank you for supporting > > > Note that my field contain only 'j' for paid > > > invoices and ' ' (empty) for non paid invoices > > > > > > Fine. in that case you don't have to test for 'J'. > > > >   filter = "betj_n = ' '" works on my test file but didn't work for you > > possibly because dBASE may have null values in the field. > > > > filter = "betj_n <> 'j'"  should return all non-paid records whether the > > field contains ' ' or null. > > > > Mervyn. > > > > >