Re: Forms 3.0 problem: Sort by non database fields

Bhaskar Manda wrote:
>
> hi
>
> i am trying to sort the rows in my Forms 3.0 form.
> any ideas on how to do this?
> thanx.
>
> -- Sivaram Manda

There isn't any easy way. What you have to do is create a database view of the information you want in your form (including the non-base-table data), and base your form on the view. However, since the data in a join-view cannot be updated directly, you are forced to write on-insert, on-update and on-delete triggers at the block level in the form to manually perform insert,update,delete.

Check out the forms advanced techniques manual, it discusses this. Received on Sat Jul 13 1996 - 00:00:00 CEST