OraFAQ Forum: Forms » Order by non base table column in forms

Home » Developer & Programmer » Forms » Order by non base table column in forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Order by non base table column in forms [message #86120]

Wed, 01 September 2004 22:07

subhasish
Messages: 33
Registered: May 2000

Member

Say , I have a table called daily_attendence with columns

emp_code
attn_date
time_in
time_out
other_det

Now in forms execute_query on above table gives the following information.

emp_id , emp_name , time_in , time_out , other_det

for a particular date.

here the non base table columns (emp_id, emp_name) is
retrieved from another table say emp_details through post query trigger.

Kindly note that emp_code and emp_id are not same.Emp_code is system generated and emp_id is the actual id of the emp.

Now my question is to get order by on emp_id(which is non base table column). How can it be done?. The records fetched are in thousands.
thanks

Report message to a moderator

Re: Order by non base table column in forms [message #86200 is a reply to message #86120]

Wed, 08 September 2004 23:34

Bir_canada
Messages: 10
Registered: July 2004

Junior Member

If u need a block just for query purpose ,then you should make that block based on from_clause_query.

But block based on from_clause_query doesnot work for insert/update/delete.

try this ...

Report message to a moderator

Previous Topic:	PLZ HELP ME ! URGENT !
Next Topic:	2 Questions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 08:08:04 CDT 2024