Subject Re: Filter From Agostinho <Agostinhoteixeira@yahoo.com > <Agostinho <Agostinhoteixeira@yahoo.com >> Date Tue, 14 Dec 2021 08:04:24 -0500 Newsgroups dbase.getting-started Dear Mattia thank you for the advice I will give a try, Have a good day Agostinho Mattia Wrote: > 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. > > > > > > > > >