OraFAQ Forum: Forms » How can i sort data in the execute Query mode during runtime

Home » Developer & Programmer » Forms » How can i sort data in the execute Query mode during runtime (Oracle 6i, Windows xp.)

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

How can i sort data in the execute Query mode during runtime [message #570741]

Thu, 15 November 2012 04:50

stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...

Senior Member

hi,

How can i sort data in the execute Query mode during runtime,
suppose i have a columns which has number, char and date field.

This below data is fetched in execute query from a table;
x1 x2 x3
1343 adfa 11/14/2012
1353 adfa 11/11/2012
1333 adfa 11/10/2012
1333 adfa 11/12/2012
1353 adfa 11/09/2012

now i like to sort like this below;

x1 x2 x3
1343 adfa 11/09/2012
1353 adfa 11/10/2012
1333 adfa 11/11/2012
1333 adfa 11/12/2012
1353 adfa 11/13/2012

how to do it?

pls explain...

Report message to a moderator

Re: How can i sort data in the execute Query mode during runtime [message #570742 is a reply to message #570741]

Thu, 15 November 2012 04:54

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

Senior Member
Account Moderator

Set data block's ORDER BY property to

order by x3

Report message to a moderator

Re: How can i sort data in the execute Query mode during runtime [message #570743 is a reply to message #570741]

Thu, 15 November 2012 05:06

stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...

Senior Member

the form is created by a Wizard so the data is not retrieved a Sql Query.
so i cannot give order by!

Report message to a moderator

Re: How can i sort data in the execute Query mode during runtime [message #570744 is a reply to message #570743]

Thu, 15 November 2012 05:10

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

Senior Member
Account Moderator

One of us is talking nonsense; can't decide who (yet). This is what I'm talking about:

/forum/fa/10512/0/

What does wizard have to do with this property?

Attachment: data_block_order_by.JPG
(Size: 53.85KB, Downloaded 2011 times)

[Updated on: Thu, 15 November 2012 05:12]

Report message to a moderator

Re: How can i sort data in the execute Query mode during runtime [message #570745 is a reply to message #570744]

Thu, 15 November 2012 05:18

stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...

Senior Member

Who is talking nonsense i cant catch you littlefoot...

well thank you very much for the answer i got it.

[Updated on: Thu, 15 November 2012 05:19]

Report message to a moderator

Previous Topic:	Installation of Oracle Forms 11g
Next Topic:	Using WEBUTIL_C_API to call C functions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 22:09:38 CDT 2024