OraFAQ Forum: Forms » Ordering of Data Displayed

Home » Developer & Programmer » Forms » Ordering of Data Displayed (Forms 10g)

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

Ordering of Data Displayed [message #456664]

Wed, 19 May 2010 03:33

isha1812
Messages: 16
Registered: January 2008

Junior Member

We are facing issue in ordering of the records in the oracle form screen.
Scenario is: We have to display 20 records at a time in the screen and on pressing previous, next button can scroll through previous 20 records and next 20 records respectively.

But the field is not coming alphabatically

We dont want create a data base View for this.
Please suggest any other approach

Report message to a moderator

Re: Ordering of Data Displayed [message #456671 is a reply to message #456664]

Wed, 19 May 2010 03:52

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Set the order by clause property on the datablock.
A view wouldn't fix this.

[Updated on: Wed, 19 May 2010 03:53]

Report message to a moderator

Re: Ordering of Data Displayed [message #456700 is a reply to message #456671]

Wed, 19 May 2010 04:52

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As of scrolling number of records up and down, we talked about it recently.

Report message to a moderator

Re: Ordering of Data Displayed [message #456738 is a reply to message #456664]

Wed, 19 May 2010 06:55

gregor
Messages: 86
Registered: March 2010
Location: Germany

Member

A little question: How do you query the records in bundles (20, next 20´..)? Do you change the DEFAULT_WHERE-Clause using, " WHERE ROWNUM</> 20 / 40 .."? --> Rownum is evaluatet before ordering.

Report message to a moderator

Re: Ordering of Data Displayed [message #456741 is a reply to message #456738]

Wed, 19 May 2010 07:04

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't think that Isha selects 20 records at a time; he (probably) fetches all of them (a simple <execute query>), but wants to jump up or down for 20 records (I guess that is the number of records displayed in a data block).

Report message to a moderator

Re: Ordering of Data Displayed [message #457228 is a reply to message #456741]

Sat, 22 May 2010 02:45

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Then set the marker, control the where clause with "rownum >= 0", "rownum => 20" and so on. This is my idea.. I don't know if there is right trigger where you can place your code.

Report message to a moderator

Re: Ordering of Data Displayed [message #457333 is a reply to message #457228]

Sun, 23 May 2010 23:47

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

Senior Member
Account Moderator

<sarcasm on>This 'rownum' idea is great if you want to bog your database server in unnecessary queries.<sarcasm off>

What's wrong with the default functionality?

David

Report message to a moderator

Previous Topic:	UI in Oracle Forms
Next Topic:	explain "reports_servlet" in web.show_document

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 03:49:53 CST 2025