Home » Developer & Programmer » Forms » how to use order by Clause in oracle form 6i (oracle form 6i)
how to use order by Clause in oracle form 6i [message #670120] Fri, 08 June 2018 12:15 Go to next message
tonyzhu
Messages: 3
Registered: June 2018
Junior Member
hi all:
now , in the order by clause of data block , I put 2 colmuns to sort , but actually ,after i excute query, there is noly first column is affected.
only sort by the first column , didn't order by these 2 columns .
here someone can help me ? thanks !
Re: how to use order by Clause in oracle form 6i [message #670144 is a reply to message #670120] Mon, 11 June 2018 02:59 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
What exactly did you put in the property?
Use get_block_property(<block name>, last_query) to check oracle has put the right order by on the query it sends to the DB.
Re: how to use order by Clause in oracle form 6i [message #670152 is a reply to message #670120] Mon, 11 June 2018 12:58 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Is the second column a varchar2 holding numbers and you think it should treat them as numbers?
Re: how to use order by Clause in oracle form 6i [message #670178 is a reply to message #670144] Thu, 14 June 2018 08:09 Go to previous messageGo to next message
tonyzhu
Messages: 3
Registered: June 2018
Junior Member
hi, thanks for your mention.
i didn't do it, i will try !
Re: how to use order by Clause in oracle form 6i [message #670179 is a reply to message #670152] Thu, 14 June 2018 08:13 Go to previous message
tonyzhu
Messages: 3
Registered: June 2018
Junior Member
thanks ! yes , these two column both are number,
Previous Topic: Form Navigation
Next Topic: Show a Report on Form Canvas like graph
Goto Forum:
  


Current Time: Thu Mar 28 15:55:39 CDT 2024