Re: Oracle forms ver 6 - execute_query does not work

From: DA Morgan <damorgan_at_psoug.org>
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.org
Received on Sat Apr 21 2007 - 21:30:33 CEST

Original text of this message