OraFAQ Forum: Forms » 'Order by' dynamically thru Forms

Home » Developer & Programmer » Forms » 'Order by' dynamically thru Forms (Forms,6i,WinXP)

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

'Order by' dynamically thru Forms [message #354025]

Thu, 16 October 2008 02:45

vdsk
Messages: 41
Registered: February 2006
Location: India & UAE

Member

I am using Forms 6i. I want to do Forms to Excel stuff and I am doing this by opening a cursor and then start Excel routine using OLE2.
The user will select the 'order by' columns from a list-item
in the form.
Problem is I have given Order by clause as given below sample, but it just don't work..
How to accomplish this ??

declare
Cursor emp_cursor is
SELECT code,name,dept,desig,salary
FROM emp
order by :s1,:s2;

begin
-- excel routine
end;

Report message to a moderator