Home » Developer & Programmer » Forms » How can i sort data in the execute Query mode during runtime (Oracle 6i, Windows xp.)
How can i sort data in the execute Query mode during runtime [message #570741] Thu, 15 November 2012 04:50 Go to next message
stalin4d
Messages: 214
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...



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 Go to previous messageGo to next message
Littlefoot
Messages: 19635
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Set data block's ORDER BY property to
order by x3
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 Go to previous messageGo to next message
stalin4d
Messages: 214
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!
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 Go to previous messageGo to next message
Littlefoot
Messages: 19635
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:

./fa/10512/0/

What does wizard have to do with this property?

[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 Go to previous message
stalin4d
Messages: 214
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:
  


Current Time: Mon Sep 22 19:33:17 CDT 2014

Total time taken to generate the page: 0.09310 seconds