Home » Developer & Programmer » Forms » Form
Form [message #581311] Thu, 04 April 2013 06:54 Go to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Hello sir,

I created Radio Group for managers,clerks,salesman,analyst and when i select any one of this , my pointer go to the "sal" column and i wrote trigger when-radio-changed GO_ITEM(:FM_SIVA.SAL);
So,please help me!.Below i attached Form for testing...I used Forms 10g version.

Thanks in advanced
Re: Form [message #581325 is a reply to message #581311] Thu, 04 April 2013 07:57 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Maybe I missed it, but - what is the problem / question?
Re: Form [message #581357 is a reply to message #581325] Fri, 05 April 2013 00:46 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Thank you sir,

1.)When i am select any one of the JOBS columns then ,pointer points at the salary column GO_ITEM(:FM_SIVA.SAL);

2.)And also Here is my trigger WHEN-VALIDATE-ITEM on COMM COLUMN,
IF :FM_SIVA.JOB='SALESMAN' AND :FM_SIVA.SAL IS NULL THEN
MESSAGE ('COMMSSION SHOULD NOT BE NULL FOR SALESMAN');
RAISE FORM_TRIGGER_FAILURE;
END IF;
Here these 2 are the problems..
please help me..

Thanks,
Re: Form [message #581362 is a reply to message #581357] Fri, 05 April 2013 01:15 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm terribly sorry, but I still don't understand what problem you might have. You explained what you did, but - what bothers you? Did the form compile? Can you run it? Is there any error when you do that? If so, which one?
Re: Form [message #581379 is a reply to message #581357] Fri, 05 April 2013 02:40 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
sivasurya wrote on Fri, 05 April 2013 06:46

1.)When i am select any one of the JOBS columns then ,pointer points at the salary column GO_ITEM(:FM_SIVA.SAL);

So the form does what you told it to do. How is that a problem?

sivasurya wrote on Fri, 05 April 2013 06:46

2.)And also Here is my trigger WHEN-VALIDATE-ITEM on COMM COLUMN,
IF :FM_SIVA.JOB='SALESMAN' AND :FM_SIVA.SAL IS NULL THEN
MESSAGE ('COMMSSION SHOULD NOT BE NULL FOR SALESMAN');
RAISE FORM_TRIGGER_FAILURE;
END IF;

That code doesn't check if the comm item is null does it?
Previous Topic: I want to populate only particular employee LOV
Next Topic: How to populate this non db block please ?
Goto Forum:
  


Current Time: Fri Mar 29 09:16:56 CDT 2024