Subject Re: filter problem From Ken Mayer, dBase, LLC <kmayer@dbasellc.com> Date Tue, 28 Sep 2021 15:03:25 -0700 Newsgroups dbase.getting-started On 9/28/2021 2:34 PM, Charlie wrote: > I'm wondering if it is possible to set a filter in a form based on not empty[field] > > I've tried this with no luck: > form.auctopen1.rowset.filter = "not empty"+[location] > > I've also tried based on this instead of not empty. > form.auctopen1.rowset.filter = [location#]+"''or"+ [location#=]+null > > But I think not empty should come up with the correct filter. Well, empty() is a function, so if it were to work, you would need to use the parentheses. However, I am not sure that the BDE's interpretation of localSQL will use recognize empty(). I did a quick test with this on a different table (not having your data): form.auctopen1.rowset.filter := "not (local ='' or location=null)" This *should* work, it's worth trying. Ken -- *Ken Mayer*, dBase, LLC Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm