| error in coding... [message #82436] |
Mon, 26 May 2003 22:25  |
Mubeen.
Messages: 37
Registered: May 2003
|
Member |
|
|
Hi friends I have put the following code in pre-block trigger at block level.I have taken 2 blocks say block1 and block2,what i want is the cursor should not pass to the next block unless the user selects any option or item from the Ist block.Please find below the code and if at all i am going somewhere wrong ,please help me in solving the problem
And while compiling the code it is showing the error 0that there are "too many declarations for set_block_property.
Any kind of help appreciated.
Here is the code:-
DECLARE
curblk VARCHAR2(30);
Alert_id number;
blk_id block;
BEGIN
curblk := :System.Cursor_Block;
blk_id := Find_block('masterblk');
IF curblk = 'masterblk' THEN
Alert_id := show_alert('block_alert');
set_block_property (blk_id,'masterblk',property_true);
else
raise form_trigger_failure;
end if;
end;
Mubeen.
|
|
|
|
| Re: error in coding... [message #82438 is a reply to message #82436] |
Tue, 27 May 2003 01:54  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
The SET_BLOCK_PROPERTY is indeed incorrect:
Set_Block_Property(block_name_or_block_id, Property, Value) and not as you use it: Set_Block_Property(block_id, Block_name, Value).
So, the following piece of code fails compilation:
set_block_property (blk_id,'masterblk',property_true);.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
