Re: Oracle Form - ORDER BY clause

Geoff White wrote:

> It is my understanding that you cannot use a function in the ORDER BY clause
> of a base table block - only a column name belonging to the base table or a
> form item.
>

SOrt of, you _can_ use a function, but indeed it needs to refer to a base table column or a form item, and I do not see where tape_id comes from. If it's on the form, the call should be sort_movie_tile_fn(:tape_id)

>
> Geoff
>
> suisum_at_ecn.ab.ca wrote:
>
> > I have the following tables. I want to get a list of movie rentals in
> > movie title for a particular customer. I have created the following
> > function in Oracle Form for sorting purpose:
> >
> > FUNCTION sort_movie_title_fn
> > (p_tape_id NUMBER)
> > RETURN VARCHAR2
> > <snip>
>
> > However, when I put the following clause in the Rentals ORDER BY clause
> > property, the form complains the invalid column name. I believe the error
> > is the tape_id.
> >
> > sort_movie_title_fn (tape_id)
> >
> > Please help.
> > <snip>

--
Met vriendelijke groet,
kind regards,

Frank van Bortel
Technical consultant Oracle
V&L Informatica BV
-----------------------------------------------
Work                           Home
Postbus 545                    Hunzestraat 4
7500 AM Enschede               7555 WB Hengelo
(31)53.434.1500                (31)74.242.5046