OraFAQ Forum: Forms » how to restrict update

Home » Developer & Programmer » Forms » how to restrict update (10gR2, windows7)

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

how to restrict update [message #560000]

Mon, 09 July 2012 02:19

7anona
Messages: 72
Registered: February 2012

Member

hellow to all
I'm trying to restrict update in a specific field in my form
I have set its property(update allowed) to no and still the field is updateable
I am also having on-commit trigger in my form level that well display a message and followed by the command commit
is it possible the trigger is overriding the property(update restriction)
please assist as soon as possible

Report message to a moderator

Re: how to restrict update [message #560002 is a reply to message #560000]

Mon, 09 July 2012 02:30

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You must have done something wrong; "Update allowed = No" works just fine for me.

/forum/fa/10294/0/

Attachment: update_allowed.jpg
(Size: 22.46KB, Downloaded 1411 times)

Report message to a moderator

Re: how to restrict update [message #560085 is a reply to message #560002]

Tue, 10 July 2012 07:43

sandeepgujje
Messages: 28
Registered: January 2012
Location: India

Junior Member

Hi

Can you please change the Property INSERT ALLOWED to NO
then it should work fine.

Hope this helps.. Smile

Report message to a moderator

Re: how to restrict update [message #560086 is a reply to message #560085]

Tue, 10 July 2012 07:45

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Update <> Insert.

So, what you are suggesting might not be correct (i.e. he doesn't want to allow updates of existing values; your option wouldn't allow inserts as well).

Report message to a moderator

Re: how to restrict update [message #560158 is a reply to message #560000]

Wed, 11 July 2012 00:51

7anona
Messages: 72
Registered: February 2012

Member

yes I want to restrict update of existing data in a specific Field
I have set the updat_allowed property to no
still the field can be updated

Report message to a moderator

Re: how to restrict update [message #560161 is a reply to message #560158]

Wed, 11 July 2012 01:06

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Is there any SET_ITEM_PROPERTY which modifies the UPDATE_ALLOWED property (and overrides what you set in Property Palette)?

Report message to a moderator

Re: how to restrict update [message #560182 is a reply to message #560161]

Wed, 11 July 2012 02:05

7anona
Messages: 72
Registered: February 2012

Member

Report message to a moderator

Re: how to restrict update [message #560220 is a reply to message #560182]

Wed, 11 July 2012 05:20

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, that's strange.

Try to create a brand new form (just use a Data Block Wizard, nothing special). Then set one of item's Update Allowed property to "No". Run the form and test its behaviour. What do you see?

Report message to a moderator

Re: how to restrict update [message #560232 is a reply to message #560220]

Wed, 11 July 2012 06:37

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

You might also want to use:
get_item_property(<item name>, update_allowed)
and
get_item_instance_property(<item name>, :system.cusor_record, update_allowed)
to ensure the property really is set to what you think it is.

Report message to a moderator

Re: how to restrict update [message #560535 is a reply to message #560232]

Sat, 14 July 2012 00:55

7anona
Messages: 72
Registered: February 2012

Member

what happened is that I was selecting from an LOV so their should have been
a constraint in the button to restrict the insertion if that filed was not null otherwise field value would change and can be saved.
in case only changing the update_allowed property to no the user would not be able to change the value by typing
but will change through pressing the button and choosing from the LOV.

Thanks to all

Report message to a moderator

Previous Topic:	Calling Java class files from PLSQL
Next Topic:	Adding Image manipulating java class

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 11 03:59:12 CST 2026