Re: ORACLE FORMS 4.5, how to use SORT in SQL query inside of When-Button-Pressed Trigger

jens_at_deutschware.com wrote:

> I have put push buttons with the colums names accross my Form,
> where
> I'm displaying a table in tabular format, in order for the
> user to
> sort by column name. I'm trying to get a simple SQL query inside
> of a
> When-Button-Pressed Trigger going. I'm getting weired errors,
> like
> you cannot do this here etc... Does this button need to be
> in a
> control block ? Right now I have it in the same canvas.
>
> I found nothing on this subject in the helpfile, any sample
> PL code
> would be appreciated. I'm almost done with my application.
>
> All I want to do is:
>
> select table.column1
> table.column2,
> table.colum3
> from table
> sort by table.column2
>

You may have more than one problem, but the first thing you should do is change "sort by" to "order by".

Al Lawson
Interactive Group, Inc.
www.interactive-group.com
lawsona_at_interactive-group.com Received on Sat Mar 08 1997 - 00:00:00 CST