Subject Re: Filter
From Mervyn Bick <invalid@invalid.invalid>
Date Mon, 13 Dec 2021 21:47:36 +0200
Newsgroups dbase.getting-started

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.