Skip to Main Content
Forums

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to apply sort on an already dispaled resultset from a procedure

750410Mar 22 2011 — edited Mar 30 2011
Hi,

I have a data block for which the 'query data source type' is PROCEDURE. When I query the block all the records in the procedure are displayed. Then I query for a specific value for the DATE column (ex: 27/07/2010) and it displays records for only 27/07/2010. Now I want to sort the displayed records.

My columns are DATE, TRANSACTION NUMBER, PROJECT CODE

I have a button each for DATE, TRANSACTION NUMBER, PROJECT CODE to do the sorting. When I click on the PROJECT CODE sort button , the already retireved records for 27/07/2010 must be sorted according to project code.
But this is not happening. The current coding will query the data block for all the records and then apply the sorting for DATE column.

Please advise.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 27 2011
Added on Mar 22 2011
#forms, #moved-from-devops
12 comments
5,198 views