Home » Developer & Programmer » Forms » FRM 40200 : FIELD IS PROTECTED AGAINST UPDATE. BUT UPDATE IS SET TO YES
FRM 40200 : FIELD IS PROTECTED AGAINST UPDATE. BUT UPDATE IS SET TO YES [message #655386] Tue, 30 August 2016 05:32 Go to next message
Soulami
Messages: 23
Registered: August 2016
Junior Member
I'M GETTING ON THE CLICK OF A BUTTON THAT FIELD IS PROTECTED AGAINST UPDATE. BUT IN THE PROPERTY PALETTE , ITS SET TO NO.

I CAN EDIT IT ON THE CLICK OF EXECUTE TWICE. WHEN I CLICK ON EXECUTE IT DOESNT ALLOWS ME TO. ON THE CLICK OF EXECUTE AGAIN THAT FIELD GETS ENABLED. THIS WAS NOT HAPPENING BEFORE
Re: FRM 40200 : FIELD IS PROTECTED AGAINST UPDATE. BUT UPDATE IS SET TO YES [message #655392 is a reply to message #655386] Tue, 30 August 2016 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 67467
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ Do NOT write the whole post in UPPER case, this is seen as YELLING and it is more likely you won't have any answer from people if you are yelling at them, they are not at in the service of you.

2/ You didn't feedback in your previous post, it is more likely you won't have any help if you don't help others by just posting the solution you ends with and don't thank people who spent time to help you.

And this will even less if you don't follow the OraFAQ Forum Guide and don't format your post accordingly to How to use [code] tags and make your code easier to read (see your previous topic).

Re: FRM 40200 : FIELD IS PROTECTED AGAINST UPDATE. BUT UPDATE IS SET TO YES [message #655393 is a reply to message #655386] Tue, 30 August 2016 06:50 Go to previous messageGo to next message
Littlefoot
Messages: 21612
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Soulami

THIS WAS NOT HAPPENING BEFORE
So, what changed since before? What modifications did you do to the form? Did you write any trigger (which modifies item settings, using SET_ITEM_PROPERTY)?


Quote:

I'M GETTING ON THE CLICK OF A BUTTON
Which button?


Quote:

I CAN EDIT IT ON THE CLICK OF EXECUTE TWICE
What is "execute"? Is it "Execute query" toolbar button, perhaps?
Re: FRM 40200 : FIELD IS PROTECTED AGAINST UPDATE. BUT UPDATE IS SET TO YES [message #655394 is a reply to message #655392] Tue, 30 August 2016 07:06 Go to previous messageGo to next message
Soulami
Messages: 23
Registered: August 2016
Junior Member

Hi Michel,

No that previous issue is in Pending Sad didn't work,

Littlefoot,

I just added my piece of code in a procedure which is being called in Key-commit trigger of form level.

before i was getting error as 'Record has been updated by another user' when i attached the same code on key-commit trigger.
Re: FRM 40200 : FIELD IS PROTECTED AGAINST UPDATE. BUT UPDATE IS SET TO YES [message #655407 is a reply to message #655394] Tue, 30 August 2016 11:08 Go to previous messageGo to next message
cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester
Senior Member
What code?
And you didn't answer LF's other questions.
Re: FRM 40200 : FIELD IS PROTECTED AGAINST UPDATE. BUT UPDATE IS SET TO YES [message #655424 is a reply to message #655407] Wed, 31 August 2016 01:43 Go to previous message
Soulami
Messages: 23
Registered: August 2016
Junior Member
Hello,

This issue got resolved.

Forgot to use the set_item_property Razz
Previous Topic: Dynamic LOV and Record Group
Next Topic: choose which lov to show
Goto Forum:
  


Current Time: Tue Oct 27 01:57:16 CDT 2020