Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Can SET_BLOCK_PROPERTY turn off sorting?

1,041 views
Skip to first unread message

Phil Carter

unread,
May 15, 1996, 3:00:00 AM5/15/96
to

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?)

Thanks for any help,
Phil Carter.

Muhammad A. Malik

unread,
May 15, 1996, 3:00:00 AM5/15/96
to Phil Carter

I guess, ROWID.

--

Muhammad A. Malik
mam...@cs.wmich.edu
+1 (616) 342-4569

Rick Rutt

unread,
May 16, 1996, 3:00:00 AM5/16/96
to

Phil Carter <car...@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.)

Phil Carter

unread,
May 17, 1996, 3:00:00 AM5/17/96
to
Have tried an empty string, null, rowid, no_property, blank string but
all to no avail.

Phil.

Lee Levy

unread,
May 19, 1996, 3:00:00 AM5/19/96
to

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....@bhp.com.au
---------------------------------------------------
Opinions expressed are mostly my own, so give me some credit.

vasya

unread,
May 22, 1996, 3:00:00 AM5/22/96
to

Phil Carter wrote:
>
> I use SET_BLOCK_PROPERTY in a Forms application to select at run-time
> which column to sort a block by. ...

You may use the following string for ORDER BY clause:
SET_BLOCK_PROPERTY('BROWSE', ORDER_BY, 'NULL');
and following string for WHERE clause:
SET_BLOCK_PROPERTY('BROWSE', DEFAULT_WHERE, '2=2');

Dmitriy Kravtsov.

0 new messages