OraFAQ Forum: Forms » HOW TO SORT BY DESCENDING ORDER IN SET BLOCK PROPERTY ORDER BY

Home » Developer & Programmer » Forms » HOW TO SORT BY DESCENDING ORDER IN SET BLOCK PROPERTY ORDER BY

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

HOW TO SORT BY DESCENDING ORDER IN SET BLOCK PROPERTY ORDER BY [message #242960]

Tue, 05 June 2007 11:00

jtc103
Messages: 19
Registered: May 2007

Junior Member

Is this possible?

I have a sort button on top of each of my columns in my detail block. What I want to do is for the user to click on the button and the details will be sorted ascending or descending order by that column. right now I can do it ascending as this is the default. I am not sure how to do it in descending order.

Report message to a moderator

Re: HOW TO SORT BY DESCENDING ORDER IN SET BLOCK PROPERTY ORDER BY [message #243047 is a reply to message #242960]

Tue, 05 June 2007 16:12

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'd use the DESC keyword. Something like this:

set_block_property('dept', order_by, 'dname desc');

Report message to a moderator

Re: HOW TO SORT BY DESCENDING ORDER IN SET BLOCK PROPERTY ORDER BY [message #243182 is a reply to message #242960]

Wed, 06 June 2007 06:33

jtc103
Messages: 19
Registered: May 2007

Junior Member

i pass a variable containing the column name and i get an error when i try to add the word desc after

so for example, my variable is v_orderyby, I tried doing

v_orderby := 'det_col1';

SET_BLOCK_PROPERTY('blk_details',ORDER_BY, v_orderby);

that works but only in the default ascening order.

Report message to a moderator

Re: HOW TO SORT BY DESCENDING ORDER IN SET BLOCK PROPERTY ORDER BY [message #243188 is a reply to message #243182]

Wed, 06 June 2007 07:15

mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait

Senior Member

try this...

v_orderby := 'det_col1 desc';

SET_BLOCK_PROPERTY('blk_details',ORDER_BY, v_orderby);

Report message to a moderator

Re: HOW TO SORT BY DESCENDING ORDER IN SET BLOCK PROPERTY ORDER BY [message #243190 is a reply to message #242960]

Wed, 06 June 2007 07:26

jtc103
Messages: 19
Registered: May 2007

Junior Member

I tried that already, and I get an ORA-06502 error.

I want to mention though that det_col1 is not the actual column name but my item name (I need to do this as I am populating my columns dynamically using the QUERY SOURCE as FROM CLAUSE.

Report message to a moderator

Re: HOW TO SORT BY DESCENDING ORDER IN SET BLOCK PROPERTY ORDER BY [message #243198 is a reply to message #243190]

Wed, 06 June 2007 07:56

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

And how exactly are we supposed to know what you are doing if you don't tell us? This is a whole new world of information!

Report message to a moderator

Re: HOW TO SORT BY DESCENDING ORDER IN SET BLOCK PROPERTY ORDER BY [message #243203 is a reply to message #243190]

Wed, 06 June 2007 08:02

mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait

Senior Member

I have written this code in 'WHEN-BUTTON-PRESSED' trigger on the button on top of a column in my form to sort it accordingly

Declare
	chk varchar2(100);
Begin
	if :global.chk_stat  = 1 then
		chk:= 'status'; -- [B][COLOR=red]Status is a column in block1[/COLOR][/B]
		SET_BLOCK_PROPERTY('BLOCK1',ORDER_BY,chk);
		go_block('block1');
		Execute_query(all_records);
		:global.chk_stat := 2;
	Else
		chk:= 'status desc';
		SET_BLOCK_PROPERTY('BLOCK1',ORDER_BY,chk);
		go_block('block1');
		Execute_query(all_records);
		:global.chk_stat := 1;
	End If;
End;

Report message to a moderator