Forms: How to let the user choose the 'order by'

From: <aut7b1p_at_sbs.de>
Date: 1997/04/22
Message-ID: <861719061.9962_at_dejanews.com>#1/1


[Quoted] [Quoted] I'm wondering that I can't find a way to make it possible to let the user [Quoted] change the order-by clause.

I've tried to use a control-block, but the required triggers themes to be somewhat difficult;
The second, I've tried to use LOV's, but I don't know how to fill the LOV at runtime with the required table-column-names or view-column-names. Third, I tried to let the user just click on the column, but this requires a lot of PL/SQL-programming, too (I've found just mouse-event triggers that I can use, the trigger must be at form-level... isn't there a thing like 'on-enter-tablecolumn' ?).

[Quoted] I'm not a PL/SQL-novice, but Oracle Forms is new to me.

Are there any code-examples, free librarys, good books (I've already read 'Oracle Developer / 2000 -Handbook from Oracle Press) or just ideas that can help ?

Thx, bye Juergen

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Tue Apr 22 1997 - 00:00:00 CEST

Original text of this message