Saving title menu filter settings when refreshing underlying dataset
Is there a way to save / retain / re-instate a filter set at runtime using the titlemenu filter whilst performing a refresh of the dataset?
I am running Delphi 10.3, Infopower VCL 4K 184.108.40.206. The dataset is an ADOQuery which, currently, I am refreshing by closing & re-opening.
Steps are as follows:
Application runs query & presents data to user.in a grid
User sets their own filter(s) etc via the title menus on the grid
User (or other users) carry out actions that changes data on server.
User now wants to update(refresh) the data in their grid without loosing their filter(s) to reflect changes.
The data is held in SQL server and I am using an ADOQuery to retrieve it. My understanding is that I need to close and re-open the ADOQuery to "refresh" the data. It is at this point that the filters are lost so I am hoping that there is a way of saving them prior to the close/re-open of the query so I can re-apply them afterwards.
Please sign in to leave a comment.