OraFAQ Forum: Forms » Problem in set_block

Home » Developer & Programmer » Forms » Problem in set_block_property

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem in set_block_property [message #168165]

Wed, 19 April 2006 02:54

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

hii all

i have a trigger of when_new_form_instance

i made in it

MESSAGE(GET_BLOCK_PROPERTY (:SYSTEM.CURRENT_BLOCK,UPDATE_ALLOWED));
MESSAGE(GET_BLOCK_PROPERTY (:SYSTEM.CURRENT_BLOCK,UPDATE_ALLOWED));

SET_BLOCK_PROPERTY (:SYSTEM.CURRENT_BLOCK,UPDATE_ALLOWED,'FALSE');

when i run the form it results on the screen

true
true
invalid parameter used for set_block_property
ora-01403: no data found

the "true" is for the message
the error for the set_block_property(:SYSTEM.CURRENT_BLOCK,UPDATE_ALLOWED,'FALSE');

how is that although i can see the property of the block thrugh the message

thanks for everyone helped and helping me

[Updated on: Wed, 19 April 2006 02:55]

Report message to a moderator

Re: Problem in set_block_property [message #168167 is a reply to message #168165]

Wed, 19 April 2006 02:58

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please check the documentation when you come across problems like this. I have the pdf open ALL day.

Quote:

UPDATE_ALLOWED Specifies whether the operator or the application
is allowed to update records in the given block. Valid values are
PROPERTY_TRUE or PROPERTY_FALSE.

That is, PROPERTY_FALSE not 'FALSE'.

David

Report message to a moderator

Re: Problem in set_block_property [message #168175 is a reply to message #168165]

Wed, 19 April 2006 03:28

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

Thanks for help

Report message to a moderator

Previous Topic:	capturing ORA-02396 in forms
Next Topic:	ENTER PROCEDURE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 10:39:59 CST 2025