Form [message #581311] |
Thu, 04 April 2013 06:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/a59247482a11edb9544247f102223e8d?s=64&d=mm&r=g) |
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 #581379 is a reply to message #581357] |
Fri, 05 April 2013 02:40 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13963 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?
|
|
|