| 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.
|
|