OraFAQ Forum: Forms » how to use order by Clause in oracle form 6i

Home » Developer & Programmer » Forms » how to use order by Clause in oracle form 6i (oracle form 6i)

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

how to use order by Clause in oracle form 6i [message #670120]

Fri, 08 June 2018 12:15

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 !

Report message to a moderator

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

cookiemonster
Messages: 13904
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.

Report message to a moderator