RE: Set where clause

Hello,

You should use this syntax --> SET_BLOCK_PROPERTY(block_id Block,
property VARCHAR, value VARCHAR); 
So, if you want to modify the WHERE clause of your block, you have to
code something like this (note that I didn't use the compiler, so I
don't know if it works!):

PROCEDURE Change_Where_Clause( block_name IN VARCHAR2 ) 
IS block_id Block;
BEGIN 
	block_id := Find_Block(block_name);
	IF NOT Id_Null(block_id) THEN 
		Set_Block_Property(blk_id,DEFAULT_WHERE,'DEPTNO = 10'); 
	ELSE 
		Message('Block '||block_name||' does not exist.'); 
		RAISE Form_Trigger_Failure;
	END IF; 
END; 



Hope this helps, goog luck!
pep0. <-- www.pep0.demon.co.uk -->



> -----Mensaje original-----
> De: Naveed [mailto:[email protected]] 
> Enviado el: miércoles, 05 de marzo de 2003 6:52
> Para: Oracle
> Asunto: [oracle] Set where clause
> 
> 
> Hi Everybody,
>  
> Actually I want to set SET_BLOCK_PROPERTY of WHERE clause. If 
> I want to fetch DEPTNO=10 then how I specify in SET_BLOCK_PROPERTY.
>  
> Your help will be much appreciated.
>  
> Kind Regards
>  
> Naveed
> 
> =======================================================
> This email and any files transmitted with it are confidential 
> and intended solely for the use of the individual or entity 
> to whom they are addressed. If you have received this email 
> in error, please notify the sender or the System 
> Administrator at [email protected] .The unauthorized 
> use, disclosure or alteration of this message is strictly 
> forbidden. Moreover, this message has been scanned for the 
> presence of computer viruses.
> 
> 
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or 
> to unsubscribe send a blank email to 
> %%email.unsub%%.
> 
> 



---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].