Discussion Locked

Sorting at Runtime Oracle

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi,

I'm using forms Developer 60 in Oracle. I wanted to change the type of sort while at Runtime for example "Surname or by Student Numer" but while changing the sorting it will not change the current Records being displayed... i'll be using set_block_property('') for this functionality.. my problem is if i use the execute_query after my set_block_property() command it will change the records being displayed...

3 replies

by twells

Have you tried to dynamically change your query so that it is ordered: ie select * from data ORDER BY Surname

by steve_a

no. i can't use the select * from order by surname.. coz it will definitely change the records displayed on the screen...

This discussion is closed to new replies.