Hi,<br>
<br>
I'm using a command button to run a procedure that adds data from a database to a flexgrid based on criteria from a textbox. I load column headers of the flexgrid in Form_load(). Once this procedure is done and rows have been added to the flexgrid, I want to be able to put different criteria in the textbox and run the procedure again but also clearing the existing data in the grid. I have tried using gridMyGrid.clear but its clearing my column headers and existing rowData and also adding the new rows after the # of rows of previous rowData. Can anyone suggest what to do to clear the grid and keep my headings. The headings are a fixed row. Thanks. Jason
<br>
I'm using a command button to run a procedure that adds data from a database to a flexgrid based on criteria from a textbox. I load column headers of the flexgrid in Form_load(). Once this procedure is done and rows have been added to the flexgrid, I want to be able to put different criteria in the textbox and run the procedure again but also clearing the existing data in the grid. I have tried using gridMyGrid.clear but its clearing my column headers and existing rowData and also adding the new rows after the # of rows of previous rowData. Can anyone suggest what to do to clear the grid and keep my headings. The headings are a fixed row. Thanks. Jason