Re: Can SET_BLOCK_PROPERTY turn off sorting?
Date: 1996/05/19
Message-ID: <4nobi7$cbq_at_gossamer.itmel.bhp.com.au>#1/1
In article <319BD175.2648_at_deakin.edu.au>, Phil Carter <carterp_at_deakin.edu.au> says:
>
>Rick Rutt wrote:
>>
>> Phil Carter <carterp_at_deakin.edu.au> writes:
>>
>> >I use SET_BLOCK_PROPERTY in a Forms application to select at run-time
>> >which column to sort a block by.
>> >
>> >But, there are times when I don't want to sort. The block's sort property
>> >has been set previously. How can I not sort?
>> >
>> >e.g. SET_BLOCK_PROPERTY('BROWSE', ORDER_BY, what goes here?)
>>
>> Have you tried passing an empty string ('')?
>>
>> -- Rick
>> --
>>
>> (Rick Rutt is a system architect living and working in Midland, Michigan.)
>Have tried an empty string, null, rowid, no_property, blank string but
>all to no avail.
>
>Phil.
I use the following technique for setting the where clause - I
cant see why the order by would be different.
DECLARE
tx_default_where_prior VARCHAR2(2000);
tx_default_where_new VARCHAR2(2000);
BEGIN
tx_default_where_prior := Get_Block_Property(<blockname>,
DEFAULT_WHERE);
tx_default_where_new := ... -- built desired string here
Set_Block_Property(<blockname>,
DEFAULT_WHERE,
tx_default_where_new);
Execute_Query;
Set_Block_Property(<blockname>,
DEFAULT_WHERE,
tx_default_where_prior);
END;
(I've typed it from memory, so dont criticise my syntax too much.)
This would work, provided you want to reset to the original value. Should be fine if your original value was blank?
HIH
Lee
Lee Levy, ISSD Technical Dream Team, Del Code (34) BHP Information Technology, ACN 006 476 213 PO Box 261, Warrawong, NSW 2502, Australia PH: +61 42 75-5485 Fax: -5500 Tie: 8855- Internet : levy.lee.ls_at_bhp.com.au
Opinions expressed are mostly my own, so give me some credit. Received on Sun May 19 1996 - 00:00:00 CEST