Subject Problem with Filters From Michael Italiano <michael@abstractservices.com.au> Date Wed, 25 Oct 2023 08:46:16 -0400 Newsgroups dbase.getting-started Hi Guys, I am definately finding alot of new quirks in DBase 2019. Especially with the BDE and Filters. Scenario. I have a table with 4 indexes on it I have an entryfield where I type what I am looking for and use the .Setrange(xchar) and it searches and displays in a grid the results. Simple bread and butter stuff, and it works very effectively. Now I can switch between each index by a combobox with the different index names and I clear the range before I search for through the next index. Again works very effectively. I can flick and search in between. I can even add the beginfilter() to narrow the data the setrange sorts between. Again very effective and works efficiently and displays the results in the grid. I will add , again have been using this source for a few years now and never noticed any problems with it.   To ensure I clear the index range and filters I have a button that issues a Clearrange(), clearfilter() as to start my searches all over again clean. Problem. Code has worked and works fine but randomly when switching between filters and indexes or when I even press the clearfilters button, randomly DBASE simply drops out, no errors, no messages, nothing. Sometimes I can search and switch betweens filters 20 or 30 times with no errors, sometimes on the first or second search it simply drops out. I can replicate the problem on a standalone form. I do not use any legacy commands all localsql commands. Again this has now destabilised my entire software and I dont understand why. Questions. I can understand why all of a sudden we have problems with filters, is there some limitation on using both applyfilter() and setrange() at the same time? Has anybody experienced issues with filters on dbase 2019? Any thoughts on how to work around? Any suggestions are appreciated. Best Regards, Michael.