OraFAQ Forum: Forms » ristrict the number of record populate= 500

Home » Developer & Programmer » Forms » ristrict the number of record populate= 500 (Oracle 10g Application Server and Oracle 10g Developer Suite)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ristrict the number of record populate= 500 [message #303954]

Mon, 03 March 2008 07:29

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

Report message to a moderator

Re: ristrict the number of record populate= 500 [message #304057 is a reply to message #303954]

Mon, 03 March 2008 22:27

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Why?

David

Report message to a moderator

Re: ristrict the number of record populate= 500 [message #304071 is a reply to message #303954]

Mon, 03 March 2008 23:39

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

Report message to a moderator

Re: ristrict the number of record populate= 500 [message #304090 is a reply to message #304071]

Tue, 04 March 2008 00:34

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: ristrict the number of record populate= 500 [message #304098 is a reply to message #304090]

Tue, 04 March 2008 00:54

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: ristrict the number of record populate= 500 [message #304624 is a reply to message #304071]

Wed, 05 March 2008 22:14

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.

Report message to a moderator

Previous Topic:	link
Next Topic:	Password type

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 22:12:38 CST 2025