dbTalk Databases Forums  

Oracle forms ver 6 - execute_query does not work

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Oracle forms ver 6 - execute_query does not work in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
pwu@qantas.com.au
 
Posts: n/a

Default Oracle forms ver 6 - execute_query does not work - 04-18-2007 , 07:04 PM






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?


Reply With Quote
  #2  
Old   
DA Morgan
 
Posts: n/a

Default Re: Oracle forms ver 6 - execute_query does not work - 04-21-2007 , 02:30 PM






pwu (AT) qantas (DOT) com.au wrote:
Quote:
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@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.