OraFAQ Forum: Forms » FRM 40200 : FIELD IS PROTECTED AGAINST UPDATE. BUT UPDATE IS SET TO YES

Home » Developer & Programmer » Forms » FRM 40200 : FIELD IS PROTECTED AGAINST UPDATE. BUT UPDATE IS SET TO YES

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

FRM 40200 : FIELD IS PROTECTED AGAINST UPDATE. BUT UPDATE IS SET TO YES [message #655386]

Tue, 30 August 2016 05:32

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

Report message to a moderator

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

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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).

Report message to a moderator

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

Littlefoot
Messages: 21826
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?

Report message to a moderator

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

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.

Report message to a moderator