| When-Mouse-Double-Click [message #79316] |
Fri, 24 May 2002 04:35  |
atul
Messages: 17
Registered: September 1999
|
Junior Member |
|
|
Hi!
I've created multi record block which is based on base table EMP.
I want to make a particular record only to be updated on which I'll double click.
This mean that if I double click on the record no. 3 then only this record could be updated and
other records must be in locking mode. Ok.
Actually I've tried with following code,
go_block('emp');
first_record;
loop
if :global.cur_rec <> :system.cursor_record then
set_block_property
('emp',update_allowed,property_false);
set_item_property
('emp.ename',enabled,property_false);
else
set_block_property
('emp',update_allowed,property_true);
set_item_property
('emp.ename',enabled,property_true);
set_item_property
('emp.ename',insert_allowed,property_true);
set_item_property
('emp.ename',update_allowed,property_true);
end if;
exit when :system.last_record = 'TRUE';
next_record;
end loop;
I've stored the current record in variable :global.cur_rec.
But using this code it enables all the records.
If any one can help me then please reply ASAP.
Thanks & Regards,
Atul
|
|
|
|
|
|
| Re: When-Mouse-Double-Click [message #79320 is a reply to message #79316] |
Fri, 24 May 2002 22:03  |
atul
Messages: 17
Registered: September 1999
|
Junior Member |
|
|
Hi Stephan!
I used Set_Item_Instance_Property built-in as follows,
set_item_instance_property('emp.ename',updateable,rec,property_false);
But it gives me error which is given below
FRM-41383: No such property for Set_Item_Instance_Property.
I think this built-in not be used in this trigger.
If u know something then please reply me.
Regards,
Atul
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
