Overblog Suivre ce blog
Editer l'article Administration Créer mon blog


Free tool

Look and Feel Project

8 novembre 2006 3 08 /11 /novembre /2006 15:04
I often see questions about how to sort a based block on a non database column.

A block sorted on a non database column

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

Partager cet article

Repost 0
Francois Degrelle - dans Oracle Forms
commenter cet article


sebastian 10/11/2006 12:51

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 10/11/2006 13:53

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