Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

frm-40105 unable to resolve reference to item button_palatte pb_first, pb_n

934520May 30 2012
dear sir i have a problem button_palatte block. there are 10 buttons but when i click the currser at product_no then 3 message comes one by one.and i also defineing 3 button traggers and procedure scroll_control,

message is that

frm-40105 unable to resolve reference to item button_palatte pb_first, pb_next, pb_prior(previous)

(1)pb_first buttion (when_button_pressed)

BEGIN

go_block('product_master');
/*Position the cursor on the first record of the current block*/
first_record;
END;
(2)pb_prior buttion (when_button_pressed)

BEGIN
go_block('product_master');
/*Position the cursor on the prior record of the current block*/
previous_record;
END;
(3)pb_next buttion (when_button_pressed)

BEGIN
go_block('product_master');
/*Position the cursor on the next record of the current block*/
next_record;
END;

scroll_control (procedure_body)

PROCEDURE SCROLL_CONTROL IS
BEGIN
/*System.last_record is a system variable that holds a value
which indicates whether the current record is the last record in a
block. It can have two values i.e. TRUE:(current record is the last
record) and FALSE:(current record is not the last record)
Cursor_record, is a system variable that holds the current record
number. If the current record number is 1 and system.last_record
is 'TRUE' all the scroll buttons should be disable since there is
only one record in the form data buffer*/

if:system.last_record='TRUE' and :system.cursor_record='1' then
set_item_property('button_palette.pb_first',enabled,property_false);
set_item_property('button_palette.pb_prior',enabled,property_false);
set_item_property('button_palette.pb_next',enabled,property_false);
set_item_property('button_palette.pb_last',enabled,property_false);

/*if the current record is the last record, the scroll buttons for first
and prior should be enabled and the scroll buttons for last and
next should be disabled*/

elsif:system.last_record='TRUE' then
set_item_property('button_palette.pb_first',enabled,property_true);
set_item_property('button_palette.pb_prior',enabled,property_true);
set_item_property('button_palette.pb_next',enabled,property_false);
set_item_property('button_palette.pb_last',enabled,property_false);

/*if the current record number is 1, the scroll buttons for first and
prior should be disabled and the scroll buttons for last and next
should be enabled*/

elsif:system.cursor_record='1' then
set_item_property('button_palette.pb_first',enabled,property_false);
set_item_property('button_palette.pb_prior',enabled,property_false);
set_item_property('button_palette.pb_next',enabled,property_true);
set_item_property('button_palette.pb_last',enabled,property_true);

/*if the current record is not the last record and the record
number is not 1 then, all the scroll buttons should be enabled*/
else
set_item_property('button_palette.pb_first',enabled,property_true);
set_item_property('button_palette.pb_prior',enabled,property_true);
set_item_property('button_palette.pb_next',enabled,property_true);
set_item_property('button_palette.pb_last',enabled,property_true);

end if;
END;


item_enable_disable (procedure_body)

PROCEDURE item_enable_disable(item_true_false in number) IS



BEGIN

set_item_property('product_master.product_no',updateable,item_true_false);
set_item_property('product_master.description',updateable,item_true_false);
set_item_property('product_master.unit_master',updateable,item_true_false);
set_item_property('product_master.qty_on_hand',updateable,item_true_false);
set_item_property('product_master.reorder_1v1',updateable,item_true_false);
set_item_property('product_master.cost_price',updateable,item_true_false);
set_item_property('product_master.selling_price',updateable,item_true_false);


END;

i hope any one solve my proble
and give me hope full answer

thanks

ali
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2012
Added on May 30 2012
0 comments
1,520 views