Goto First Page of a Copied Table

[geadon]

I have two tables. Table A contains all my data. I am querying that table then copying those results to Table B. After copying to Table B, if Table B has multiple pages (too many rows to show in one page), the table takes me to the last page. How do I get it to jump back to the first page.

It seems like something simple but I can't seem to get it to work. Below is what I have in it's most simple form. I have tried getting the rows from the table and iterating through but that seems like an overkill for what I'm doing and still doesn't seem to work.

Code: Select all

tables.TableA.fetchTable();
tables.TableB.copyTable(tables.TableA, true);
tables.TableB.setCurrentRow(0);

I am aware that I could just change the sort direction on the table but this isn't really how I want to display the data.

Thanks

[geadon]

Found the solution (thanks to a colleague)....

Code: Select all

controls.TableControl.visibleRow = controls.TableControl.firstDisplayRow;