Home » Developer & Programmer » Forms » frm-41051:you cannot create records here (forms 10g)
frm-41051:you cannot create records here [message #398530] Thu, 16 April 2009 10:13 Go to next message
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
Re: frm-41051:you cannot create records here [message #398562 is a reply to message #398530] Thu, 16 April 2009 14:11 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you check block's insert/update allowed properties?
Re: frm-41051:you cannot create records here [message #398567 is a reply to message #398562] Thu, 16 April 2009 14:41 Go to previous messageGo to next message
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
Re: frm-41051:you cannot create records here [message #398570 is a reply to message #398567] Thu, 16 April 2009 14:47 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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).
Re: frm-41051:you cannot create records here [message #398580 is a reply to message #398570] Thu, 16 April 2009 15:39 Go to previous messageGo to next message
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:

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
Re: frm-41051:you cannot create records here [message #398599 is a reply to message #398580] Thu, 16 April 2009 21:01 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Yes you are changing the business.

David
Previous Topic: Closing a file.
Next Topic: WEB.SHOW_DOCUMENT
Goto Forum:
  


Current Time: Sat Dec 10 11:00:27 CST 2016

Total time taken to generate the page: 0.05910 seconds