Posted by [IP Address: 129.22.241.191] 'Cindy' on August 22, 2001 at 13:18:19 EST:
Hi all,
I have a panel with a grid. Originally when the panel is loaded it display all rows in the grid. I have a criteria prompt in level 0 for user to enter the criteria and a 'go' button to display only the rows(based on user selected criteria), and that works fine. I tried to add another button in level 0 say 'Refresh' which I hope will reload all rows that was orignally loaded in the grid if user decides to see all rows again. Somehow, when 'Refresh' button is pressed, the rows in the grid remains the same(display only those rows based on user's criteria).
The 'Refresh' button looks like this:
......
ScrollFlush(RECORD.RECORDA);
ScrollSelect(1, RECORD.RECORDA, RECORD.RECORDA, "Where SSN =:1 order by Fiscal_Year Desc, Accounting_Period Desc", &SSN);
.....
The code for ScrollSelect is exactly the same as in RowInit when panel is first loaded.
Any help are appreciated. Thanks.
Cindy