Re: Forms 3.0: Sort on non-db field, how-to

JamesRichard wrote:
: In article <48ajl3$4a2_at_lll-winken.llnl.gov>, 68a869_at_llnl.gov (Jeff Busch)
: writes:
 

: >I have a forms 3.0 form which has a base-table block for an employee
: >profile. The table contains an employee ID, and the employee name is
: >retrieved in a POST-QUERY trigger.
: >
: >Does anyone know how I can sort the records on the employee name?
: >
: >---
: >Jeff Busch Internet busch1_at_llnl.gov
: >Voice (510) 423-9134 Fax (408) 263-1360

: Unfortunately, it can't. /*Tried it... didn't work.*/
: If you are not updating/creating, create a view and query the view.
 

: Sorry I couldn't be of any more help.
 

: James Richard
: {JRichard_at_TUNS.CA, http://www.tuns.ca/~jrichard/}
: 'No Assembler Required!'

--

If you are using Oracle 7.1.3 or later, you can write a PL/SQL function which
you can call in the order by clause of you forms 3.0. The function would 
return the name for an employee id. 

I have done a similar thing before and it works. 

Hope this helps.

---------------------------------------------------------------------------
Kannan 
Email: skannan_at_fs.com
Mastech Systems Corporation

The above are my own comments and opinion. They do not purport that of 
anybody else.
       ** Different is Not Better. Better is not Different. **
---------------------------------------------------------------------------