Re: Oracle forms ver 6 - execute_query does not work
Date: Sat, 21 Apr 2007 12:30:33 -0700
Message-ID: <1177183833.467137_at_bubbleator.drizzle.com>
pwu_at_qantas.com.au wrote:
> Hi,
>
> I have an Oracle table called missawb.
>
> On my oracle form I have a group of text fields that repesent the
> table. It displays
> 10 rows at a time with a scrollbar.
>
> I have a button on the form that loads the missawb table via a stored
> procedure:
> dropout_pkg.misspayment(30);
>
> Then does the following:
> go_block('MISSAWB');
> execute_query(ALL_RECORDS);
>
> Now the table has been loaded with 44,000 records so I would expect
> that the
> scrollbar is enabled but it is not.
>
> However if I do the F7/F8 combination on the missawb block - the
> scrollbar is enabled and
> works!
>
> Can someone please tell me why the execute_query does not enable the
> scrollbar?
I've never seen this behavior before but then I haven't seen Forms 6 in many years. Any chance you can upgrade to a supported version?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sat Apr 21 2007 - 21:30:33 CEST