Subject Re: filter problem From charlie <tm@tc.com> Date Tue, 28 Sep 2021 19:40:03 -0400 Newsgroups dbase.getting-started Ken thanks so much.  That worked! Ken Mayer, dBase, LLC Wrote: > 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