OraFAQ Forum: Forms » forms

Home » Developer & Programmer » Forms » forms_radio button

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

forms_radio button [message #631593]

Thu, 15 January 2015 14:30

palpali
Messages: 138
Registered: December 2014
Location: India

Senior Member

Hallo all

I am looking for your help please..

I would like to try my form below(attached file) with radio button function. its a master-detail block.
and I would like to make it work.
1) if radio button (all) is selected then will do the normal function as master-detail do. But,
2) if radio button (dept) is selected then, in block employees1, all the fields should be disabled and the user will give the new department_id in text item (search) and it will show the records in then employees1 b1ock again with the respective department_id.
But somehow it does not work the normal master-detail too.. i dont know why:(
can anyone please help me?
i hope for your great help.
thankx you
regards.

Attachment: my_test.fmb
(Size: 92.00KB, Downloaded 1487 times)

Report message to a moderator

Re: forms_radio button [message #631675 is a reply to message #631593]

Fri, 16 January 2015 23:30

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

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

Re: forms_radio button [message #631689 is a reply to message #631593]

Sat, 17 January 2015 12:58

palpali
Messages: 138
Registered: December 2014
Location: India

Senior Member

HI..
Thankx for your reply..
i will try as per your suggestion. Thankx alot Smile

regards.

Report message to a moderator

Re: forms_radio button [message #631695 is a reply to message #631675]

Sun, 18 January 2015 13:38

palpali
Messages: 138
Registered: December 2014
Location: India

Senior Member

Hi jgjeetu

i tried as you have written, i made a trigger WHEN-NEW-BLOCK-INSTANCE and put the code as per your guidelines but still i am not getting my output as i wanted too.
can you please help me on this regards?
thankx in advance

regards

Report message to a moderator

Re: forms_radio button [message #631724 is a reply to message #631695]

Mon, 19 January 2015 03:24

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

@PAPALI
As per your requirement i have made this forms using emp and dept table.
you can easily understand the concept through this form.
i have attached the .fmb file. do check the form_level_trigger and trigger written on radio button. let me know if you still need help.

Attachment: radio.fmb
(Size: 100.00KB, Downloaded 1217 times)

Report message to a moderator

Re: forms_radio button [message #631739 is a reply to message #631724]

Mon, 19 January 2015 05:39

palpali
Messages: 138
Registered: December 2014
Location: India

Senior Member

Hi jgjeetu

thank yopu very much for your Kind co-operation and guidance.
hope to get further help agian Smile

regards

Report message to a moderator

Previous Topic:	jacob file Isseu in Webutil
Next Topic:	Problem with inserting in the a trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 10:19:38 CDT 2024