|Re: Syntax to set the property of a block [message #332087 is a reply to message #332061]
||Mon, 07 July 2008 08:41
Registered: March 2005
Remember, Help present in Form developer is very good.|
Here is example, related to your problem, present in that help.
** Built-in: SET_BLOCK_PROPERTY
** Example: Prevent future inserts, updates, and deletes to
** queried records in the block whose name is
** passed as an argument to this procedure.
PROCEDURE Make_Block_Query_Only( blk_name IN VARCHAR2 )
/* Lookup the block's internal ID */
blk_id := Find_Block(blk_name);
** If the block exists (ie the ID is Not NULL) then set
** the three properties for this block. Otherwise signal
** an error.
IF NOT Id_Null(blk_id) THEN
Message('Block '||blk_name||' does not exist.');
[Updated on: Mon, 07 July 2008 08:43]
Report message to a moderator