Home » Developer & Programmer » Forms » ristrict the number of record populate= 500 (Oracle 10g Application Server and Oracle 10g Developer Suite)
ristrict the number of record populate= 500 [message #303954] Mon, 03 March 2008 07:29 Go to next message
itroome
Messages: 34
Registered: June 2005
Location: DUBAI, UAE
Member

Dear Guru

How I can ristrict the number of record populate= 500 after the execute query.

Muhammad Aurangzaib

Sr. Application Developer (LARA)
CMA CGM

Dubai, U.A.E
Phone.: +971 4 375 7336 , + 971 50 9511419

Email: itroome@yahoo.com

Re: ristrict the number of record populate= 500 [message #304057 is a reply to message #303954] Mon, 03 March 2008 22:27 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Why?

David
Re: ristrict the number of record populate= 500 [message #304071 is a reply to message #303954] Mon, 03 March 2008 23:39 Go to previous messageGo to next message
itroome
Messages: 34
Registered: June 2005
Location: DUBAI, UAE
Member

Dear David

Acutally, I want to display the maximum number of record in the result of execute query list will be limited by 500.


for example when i enter the critria there may populate the records more then 5000. but I want only show first 500 records rest will not display in the result and more over there should be a information for displayed record = 500. This is requirement to imrove the perforamce of form.




Wait for your soluation
Re: ristrict the number of record populate= 500 [message #304090 is a reply to message #304071] Tue, 04 March 2008 00:34 Go to previous messageGo to next message
Littlefoot
Messages: 20893
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, I'd rather test forms' behaviour by setting the "Query Array Size" and "Number of Records Buffered" data block properties.
Re: ristrict the number of record populate= 500 [message #304098 is a reply to message #304090] Tue, 04 March 2008 00:54 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I agree with Littlefoot. Consider using different values for the 'Optimizer Hint' property of the block, for example, 'first_rows'.

David
Re: ristrict the number of record populate= 500 [message #304624 is a reply to message #304071] Wed, 05 March 2008 22:14 Go to previous message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

you can try typing the following SQL query:

query:
-------------------------------
SELECT EMPNO,EANME FROM EMP
HAVING MAX(ROWNUM)<=5
GROUP BY EMPNO,ENAME,SAL ORDER BY SAL DESC
------------------------------

output:

EMPNO ENAME
------ ----------
7566 JONES
7499 ALLEN
7654 MARTIN
7521 WARD
7369 SMITH


thank you.

dbhossain

Note: at line no. 2 you can
put 500 or whatever instead of 5
as per your populating requirement.


Previous Topic: link
Next Topic: Password type
Goto Forum:
  


Current Time: Mon Dec 05 06:45:32 CST 2016

Total time taken to generate the page: 0.08750 seconds