I'm using a component one VSFlexgrid Pro version 8. I am using this filter to filter the recordset.
Adodc1.Recordset.Filter = "payappID = '" & Text2.Text & " '"
In any of the bound Data modes available in the grid the filter works just fine. However I need to use it in the Data mode flexDMFree but then it just totally ignores the filter and loads everything and doesn't give me any errors. This mode loads the grid with data then disconnects the recordset so you can edit any cells then add a new record to the DB based on the gird information.
Anyone ever seen this problem or can help with a solution.
Thanks for any and all help.
Adodc1.Recordset.Filter = "payappID = '" & Text2.Text & " '"
In any of the bound Data modes available in the grid the filter works just fine. However I need to use it in the Data mode flexDMFree but then it just totally ignores the filter and loads everything and doesn't give me any errors. This mode loads the grid with data then disconnects the recordset so you can edit any cells then add a new record to the DB based on the gird information.
Anyone ever seen this problem or can help with a solution.
Thanks for any and all help.