Re: Oracle Form - ORDER BY clause

From: <suisum_at_ecn.ab.ca>
Date: 23 Apr 99 03:13:53 GMT
Message-ID: <371fe571.0_at_ecn.ab.ca>

Hi Frank:

Sorry, me again.

I found out what the problem is. The function should be in Server level. But I put it in the form's program unit. It works fine now. The correct syntax should be:

  sort_movie_title_fn(tape_id)

Thanks,

---

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 Received on Fri Apr 23 1999 - 05:13:53 CEST