I am using a TQuery to Sort and Filter records. It works fine.
However, if I click on a record from the resulting set in a DBGrid and try to Sort on it or filter on it to narrow the results I will not necessarily sort/filter on the selected value. I believe that this is due to the ActiveRecord in the Grid not being in sync with the CurrentRecord of the table. I have looked through the help and can't find a way to move the cursor in the table to the record in use by the
Grid. Anyone know how to do this?
However, if I click on a record from the resulting set in a DBGrid and try to Sort on it or filter on it to narrow the results I will not necessarily sort/filter on the selected value. I believe that this is due to the ActiveRecord in the Grid not being in sync with the CurrentRecord of the table. I have looked through the help and can't find a way to move the cursor in the table to the record in use by the
Grid. Anyone know how to do this?