OraFAQ Forum: Forms » frm-41051:you cannot create records here

Home » Developer & Programmer » Forms » frm-41051:you cannot create records here (forms 10g)

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

frm-41051:you cannot create records here [message #398530]

Thu, 16 April 2009 10:13

nastyjillu
Messages: 211
Registered: February 2009

Senior Member

i have a date field. when i click on the button and open calender and click on some date, it says :
frm-41051:you cannot create records here.

then i made 'insert allowed', 'update allowed' property of both the block and the field to 'yes'.

even though its showing the same error.

what might be the solution??

thanks
jillu

Report message to a moderator

Re: frm-41051:you cannot create records here [message #398562 is a reply to message #398530]

Thu, 16 April 2009 14:11

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

Senior Member
Account Moderator

Did you check block's insert/update allowed properties?

Report message to a moderator

Re: frm-41051:you cannot create records here [message #398567 is a reply to message #398562]

Thu, 16 April 2009 14:41

nastyjillu
Messages: 211
Registered: February 2009

Senior Member

yes, insert/update allowed for block is 'yes'. even though iam getting the error.

when iam trying to type some letters in that field or other field called dsp_name, iam getting below error
frm-40200: field is protected against update.

even though update allowed is 'yes' for block and also for those fields. then why this error??

thanks
jillu

Report message to a moderator

Re: frm-41051:you cannot create records here [message #398570 is a reply to message #398567]

Thu, 16 April 2009 14:47

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

Senior Member
Account Moderator

Did you programatically changed block/item properties? Search for SET_ITEM_PROPERTY or SET_BLOCK_PROPERTY. Also, try to recompile the form (Ctrl + Shift + K).

Report message to a moderator

Re: frm-41051:you cannot create records here [message #398580 is a reply to message #398570]

Thu, 16 April 2009 15:39

nastyjillu
Messages: 211
Registered: February 2009

Senior Member

i got it. in the when-new-block-instance trigger of that block i wrote below code:

Code: [Select all] [Show/ hide]

if get_block_property('PC',INSERT_ALLOWED)='FALSE' THEN
	Set_block_property('PC',INSERT_ALLOWED,PROPERTY_TRUE);
END IF;
if get_block_property('PC',UPDATE_ALLOWED)='FALSE' THEN
	
	Set_block_property('PC',UPDATE_ALLOWED,PROPERTY_TRUE);

	END IF;

it allows me to insert. but my question is, am i changing the business by allowing insert and update to 'yes'???

thanks
jillu

Report message to a moderator

Re: frm-41051:you cannot create records here [message #398599 is a reply to message #398580]

Thu, 16 April 2009 21:01

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

Senior Member
Account Moderator

Yes you are changing the business.

David

Report message to a moderator

Previous Topic:	Closing a file.
Next Topic:	WEB.SHOW_DOCUMENT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 16 02:52:42 CDT 2025