|
Re: forms_radio button [message #631675 is a reply to message #631593] |
Fri, 16 January 2015 23:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/179476.png) |
jgjeetu
Messages: 373 Registered: July 2013 Location: www.Orafaq.com/Forum
|
Senior Member |
![jgjeetu@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
create a variable where and store where condition in that variable , and try to use it
in set_block_property builtin in default where clause. example given below would help you achieving your target.
ex.
set_block_property('blockname',default_where,condition)
--WHEN_NEW_BLOCK_INSTANCE TRIGGER
declare
p_where varchar2(1000);
begin
p_where:='deptno=10; or 'deptno='||:block.item;
set_block_property('emp',default_where,p_where);
end;
if you still face any problem then let me know i will provide you .fmb file as per your requirement.
[Updated on: Fri, 16 January 2015 23:30] Report message to a moderator
|
|
|
|
|
|
|