Re: Set Block Property in Oracle

From: Mark Gumbs <mgumbs_at_hotmail.com>
Date: Fri, 19 Mar 1999 09:26:17 -0000
Message-ID: <36f21762.0@145.227.194.253>

Sounds strange!
All i could suggest is putting the block name before the :ssno just in case you have another :ssno on the form which the query is getting confused with.

Mark

amitabh12_at_my-dejanews.com wrote in message <7crf1a$vrp$1_at_nnrp1.dejanews.com>...
>hi,
> I have a non database block and when I put in the following trigger
> it doesnt return anything.
> GO_BLOCK('name of the database block');
> SET_BLOCK_PROPERTY('name_of_the_block',DEFAULT_WHERE,'ssno < :ssno');
> EXECUTE_QUERY;
>
> but now if I do the following it works :GLOBAL.ssno = :ssno;
>GO_BLOCK('name of the database block');
>SET_BLOCK_PROPERTY('name_of_the_block',DEFAULT_WHERE,'ssno <
:GLOBAL.ssno');
>EXECUTE_QUERY;
>
>Any reason why is that, and secondly if anyone knows how to make it work
>without using Globals I would really appreciate their help
>
>Thanks
>Munish
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Mar 19 1999 - 03:26:17 CST