Posted by [IP Address: 129.22.241.191] 'Cindy' on August 23, 2001 at 13:38:53 EST:

In Reply to: Re: ScrollSelect question posted by [IP Address: 129.22.241.191] 'hth' on August 22, 2001 at 23:01:03 EST:

Hi,

Sorry that I probably did not make my question clear enough. My 'Go' button looks like this:
........
ScrollFlush(RECORD.RECORDA);
ScrollSelect(1, RECORD.RECORDA, RECORD.RECORDA, "Where SSN =:1 and FISCAL_YEAR = :2 and ACCOUNTING_PERIOD = :3", SSN, FISCAL_YEAR, ACCOUNTING_PERIOD);
.........
which display only those rows selected based on the criteria user entered.

While my '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);
........................
which I hope to display all rows for this person.

I think it has something to do with the panel buffer but I don't know why... and how to fix it...

Thanks.

Cindy

: Try this -

: when the user hits refresh, is the criteria box cleared?

: add code before you do the scroll actions in the Refresh Button to clear the value in user criteria box

: hth

Follow Ups:

• Re: ScrollSelect question hth 23:43:44 8/23/01 EST (1)
  • Re: ScrollSelect question Cindy 10:18:21 8/24/01 EST (0)

Post a Followup