Forms : A based block sorted on a non database column

I often see questions about how to sort a based block on a non database column.



This is a "how-to" that does the trick.

Comments

[sebastian]

Hi François
There is another way to do this :
The steps 1, 2 and 3 are the same. 
Step 4 : for your data block property, in the Advanced database node,  in  the DML_DATA_TARGET_NAME property, specify the table name (in your example EMP)
Step 5 : for your item total, put the QUERY ONLY property to yes
And that's all, you don't have to write any code.

[Francois Degrelle]

Yes sebastian, if the query is about a single table, you are right  ;o)Thanks for the tip.