Subject (no subject) From AGOSTINHO <AGOSTINHOTEIXEIRA@YAHOO.COM> Date Sun, 12 Dec 2021 23:37:16 -0500 Newsgroups dbase.getting-started Dear group This is my debtors file I want to filter all the non paid records, all the paid invoices are marked with "j" and the non paid invoices are not marked just left '  ' (empty) Now I need  to get all the non paid invoices filtered I've tried to do the following  but there is no way I can get the file filtered. How do I solve this issue? this.DEBITEUR1 = new QUERY(this)    with (this.DEBITEUR1)       left = 61.0       top = 1.0       sql = 'select * from "C:\DBASE5\START\DEBITEUR.DBF"  where klant_code = :code '       params["code"] = ""       masterSource = form.clients1.rowset       active = true    endwith    with (this.DEBITEUR1.rowset)       filter = "betj_n = ' '"    endwith Thanks Agostinho