"FRM-41042 no such property for set_item_property" [message #261519] |
Wed, 22 August 2007 22:44 |
sams
Messages: 100 Registered: August 2007
|
Senior Member |
|
|
i have written code to insert record in table:
declare
blk_name varchar(60);
form_name varchar(60);
begin
create_record;
form_name:=get_application_property(current_form_name);
blk_name:= get_form_property(form_name,first_block);
item_enable_disable(blk_name,property_on);
end;
And to save record i wrote code:
commit_form;
now i want to insert and save my record only when one button pressed.so when i combine this code this gives error message:
"FRM-41042 no such property for set_item_property"
it is inserting record properly but why this message occured?
full code:
declare
blk_name varchar(60);
form_name varchar(60);
begin
create_record;
form_name:=get_application_property(current_form_name);
blk_name:= get_form_property(form_name,first_block);
item_enable_disable(blk_name,property_on);
commit_form;
end;
any solution?
thnks
|
|
|
|
Re: "FRM-41042 no such property for set_item_property" [message #261581 is a reply to message #261548] |
Thu, 23 August 2007 01:31 |
sams
Messages: 100 Registered: August 2007
|
Senior Member |
|
|
but when i run this code(procedure item_enable_disable) individually ,it runs sucessfully.
without any error message
when i write inser record code on "insert button" it runs sucessfully and insert record.
and when i write save code on save button "commit_form". it works sucessfully.
i want to write both codes on one button "insert and save"
"then error occurs"
FRM-41042 no such property for set_item_property
|
|
|
|
Re: "FRM-41042 no such property for set_item_property" [message #263747 is a reply to message #261630] |
Thu, 30 August 2007 23:32 |
sams
Messages: 100 Registered: August 2007
|
Senior Member |
|
|
This is the procedure:
PROCEDURE item_enable_disable(blk_name IN char , item_on_off IN NUMBER) IS
nxt_itemname varchar2(70);
itemtype varchar2(25);
itemcanvas varchar2(25);
BEGIN
nxt_itemname:=blk_name ||'.'||get_block_property(blk_name,first_item);
loop
itemtype:=get_item_property(nxt_itemname,item_type);
itemcanvas:=get_item_property(nxt_itemname,item_canvas);
if (itemtype<>'DISPLY ITEM') and (itemcanvas is not null)
and (get_item_property(nxt_itemname,enabled) = 'TRUE')then
set_item_property(nxt_itemname,updateable,ITEM_ON_OFF);
end if;
nxt_itemname:=blk_name||'.'||get_item_property(nxt_itemname,next_navigation_item);
if(nxt_itemname=blk_name||'.ROWID') then
exit;
end if;
end loop;
END;
|
|
|
|
|
|
Re: "FRM-41042 no such property for set_item_property" [message #264215 is a reply to message #264156] |
Sun, 02 September 2007 01:44 |
bbaz
Messages: 138 Registered: April 2007
|
Senior Member |
|
|
This is what I found on Oracle 10g Forms Reference:
Quote: |
Propagation of Property Changes You can only specify a change to one item property at a time through the SET_ITEM_PROPERTY Built-in. However, one SET_ITEM_PROPERTY statement can cause changes to more than one item property if the additional changes are necessary to complete, or propagate, the intended change. This is included primarily for compatibility with prior versions.
The following table shows the SET_ITEM_PROPERTY settings that cause Oracle Forms to propagate changes across item properties:
Setting this property parameter...
To this setting
Also causes these propagated changes:
ENABLED
False
sets the Navigable item property to False
sets the Update_Null item property to False
sets the Updateable item property to False
VISIBLE
False
sets the Enabled and Navigable item properties to False
sets the Updateable item property to False
sets the Update_Null item property to False
sets the Queryable item property to False
UPDATEABLE
True
sets the Update_Null item property to False
UPDATE_NULL
True
sets the Updateable item property to False
|
Hope this Helps.
http://www.oracle.com/webapps/online-help/forms/10g/state?navSetId=_&navId=0
|
|
|
|
|
|
|
|
|