| 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
|
|
|
|
|
|
| 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
|
|
|
|
|
|
| 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:
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
