Re: Oracle Form - ORDER BY clause

From: <suisum_at_ecn.ab.ca>
Date: 23 Apr 99 01:58:50 GMT
Message-ID: <371fd3da.0_at_ecn.ab.ca>

Hi Frank:

Thank you for your information.

I have tried put the following in the ORDER clause, but I still got an error.

   sort_movie_title_fn (:rentals.tape_id)    sort_movie_title_fn (:tape_id)

  where the 'rentals' is the name of the data block.

Error:

---

SELECT ROWID,CUSTOMER_ID,TAPE_ID,RENT_DT,RETURN_DT,DAILY_RATE FROM RENTALS WHERE (CUSTOMER_ID=:1) order by sort_movie_title_fn (:tape_id)

ORA-00904: invalid column name

Best regards,

Frank van Bortel (f.van.bortel_at_vnl.nl) wrote: : 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)

Received on Fri Apr 23 1999 - 03:58:50 CEST