| Unable to make the form fields available to edit [message #575994] |
Wed, 30 January 2013 07:36  |
Nshan
Messages: 62
Registered: February 2009
|
Member |
|
|
Hi All,
My requirement is to call a form through special menu icon from one main form and display some information.
Whenever i open a new form it should fetch a record and display where some of the fields should be available to edit.
I am displaying a record based on a view.
For that i have used below code in when-new-form-instance
- GO_BLOCK('Block name');
- DO_KEY('Execute_Query');
After executing the query my block status is becoming 'QUERY' where i am not able to set the block/item property "Update allowed" to true.
I have added below piece of code
set_item_property('block_name.item name',insert_allowed, PROPERTY_TRUE);
set_item_property('block_name.item name',UPDATE_ALLOWED,PROPERTY_TRUE);
in almost all the triggers and tried.
I could still see all the fields are read only.
Could any one please me on this issue.
Thanks,
Nshan.
|
|
|
|
|
|
|
|
|
|
| Re: Unable to make the form fields available to edit [message #576161 is a reply to message #576000] |
Fri, 01 February 2013 01:09  |
Nshan
Messages: 62
Registered: February 2009
|
Member |
|
|
Hi,
My form becomes non editable as my form is based on a view. If it is based on a table then setting item edit properties would be possible.
I need to add either NULL/ whatever code ex: some execution code in
- ON INSERT
- ON UPDATE
- ON DELETE
triggers and this will allow you to set edit ability to the items in that form.
But still not understand how come adding null / some code in those triggers allow us to set edit ability to the items.
Thanks for the reply.
Thanks,
Nshan.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
