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

SET_BLOCK_PROPERTY - DEFAULT_WHERE Problem

7,380 views
Skip to first unread message

Daniel Morgan

unread,
Aug 29, 2002, 4:43:10 PM8/29/02
to
Finally ran into something where neither HELP, nor Oracle docs, nor my
book collection seems to be able to provide an answer or a workaround.

Has anyone figured out how to get past this in Oracle Froms 6i?

SET_BLOCK_PROPERTY('permit_request', DEFAULT_WHERE, 'permit_request_no =
' || :workorder_permit.permit_request_no);

Alters the default WHERE clause and adds the above parameter ... good so
far.

But there seems to be no way to get back to the default WHERE clause.
Which in most cases for this particular form is no WHERE clause at all.

Any suggestions welcome.

Thanks,

Daniel Morgan

Andy Hardy

unread,
Aug 29, 2002, 5:51:47 PM8/29/02
to
In message <3D6E8744...@exesolutions.com> , Daniel Morgan
<dmo...@exesolutions.com> writes

How about storing the original DEFAULT_WHERE property before you change
it (using get_block_property) and reset it after use?

Andy
--
Andy Hardy. PGP ID: 0xA62A4849

justme

unread,
Aug 29, 2002, 7:09:00 PM8/29/02
to
set the default where to '' if you want blank
"Daniel Morgan" <dmo...@exesolutions.com> wrote in message
news:3D6E8744...@exesolutions.com...

Daniel Morgan

unread,
Aug 30, 2002, 2:10:07 PM8/30/02
to
Thanks.

Daniel Morgan

iam_narayanan

unread,
Dec 12, 2002, 2:45:33 AM12/12/02
to

This is regarding Orderby in an control block or non base table block
using set_block_property(<blockname>,default_where,<?>')
can u help on this.

Originally posted by Daniel Morgan

--
Posted via http://dbforums.com

URNinja-ed

unread,
Dec 12, 2002, 5:51:48 AM12/12/02
to
strange... the obvious answer is:

set_block_property(<block_name>, default_where, '');

and it works for me fine.

iam_narayanan wrote:

--
Suzuki SV650S - plop.  Gone.
Kwak ZX-6R J2 - hear the roar
 

jayant.d...@gmail.com

unread,
Oct 11, 2018, 9:02:11 AM10/11/18
to
Hi All,

I get error (ora 06502) while executing the below code. Pls help

DECLARE
CRI VARCHAR2(100);
PER VARCHAR2(5);
BEGIN
PER := '%';
IF :CONTROL.CHOICE = 1 THEN
CRI := 'INVH_DT BETWEEN '''||:CONTROL.FRDT||''''||'AND'''||:CONTROL.TODT||''''||
'AND INVH_DOC_SRC_LOCN_CODE = '''||:CONTROL.LOC||'''';
ELSIF :CONTROL.CHOICE = 2 THEN
CRI := 'INVH_DT BETWEEN '''||:CONTROL.FRDT||''''||'AND'''||:CONTROL.TODT||''''||
'AND INVH_DOC_SRC_LOCN_CODE ='''||:CONTROL.LOC||''''||
'AND INVH_CUST_NAME LIKE '''||PER||UPPER(:CONTROL.TEXT1)||PER||'''';
END IF;

SET_BLOCK_PROPERTY('OT_INVOICE_HEAD',DEFAULT_WHERE,CRI);
GO_BLOCK('OT_INVOICE_HEAD');
EXECUTE_QUERY(NO_VALIDATE);
END;

docd...@panix.com

unread,
Oct 11, 2018, 8:38:06 PM10/11/18
to
In article <d5755f90-faba-42e7...@googlegroups.com>,
<jayant.d...@gmail.com> wrote:


[posted and emailed]

[snip]

>Hi All,
>
>I get error (ora 06502) while executing the below code.

What error do you get when you don't execute it?

DD
0 new messages