Originally Posted 29 April 2013, 2:23 pm ESTWe are evaluating the TrueDBGrid for an application that requires filtering of data. The behavior we are looking for is exactly what the FilterBar tutorial example is doing (step 29 in the tutorial samples for ActiveX)
From the documentation I have been reading and the ActiveX samples it looks like the actual filtering is not really done by the Grid itself but by the data source. So, for instance the FilterBar example uses an mdb to hold data and sends an SQL statement to filter the get a new recordset.
The data we'd like to display is not stored in an mdb but comes over the wire. Storing it in an mdb is not an option. Is using XArrayDB the suggested approach? If so, how would the filtering work there? Would we have to use the XArrayDB.Find method to find all and the re-load the Grid.
Thanks for your help.