| PLEASE SUGGEST :Not null check for an LOV item at item level and the same (merged) [message #165692] |
Fri, 31 March 2006 09:18  |
orafaametta
Messages: 11
Registered: March 2005
Location: Hyb
|
Junior Member |
|
|
Hi All,
I am working in a customized database application being devloped using FORMS6i and oracle8i,
the application will be deployed over web.
I have to implement a restriction on all mandatory LOV items in the application,in such a way that as soon as user navigates to other field while keeping that non null LOV item empty,he must be prompted for message and forced to provide a value for the item.
I am achieving this in WHEN-VALIDATE-ITEM trigger for NON LOV items like this
If 'BLOCK_NAME.ITEM_NAME' is null then
Message('Provide the value here');
Message('Provide the value here');
Raise form_trigger_failure;
End if;
IF i write the same code in WHEN-VALIDATE-ITEM for LOV ITEMS,then LOV will not be displyed when cursor(control) is in that LOV item and user presses LOV button. I found that instead of displyig LOV the WHEN-VALIDATE-ITEM trigger fires and raises Form_trigger_Failure with the message 'Provide the value here'
(it seems it is validating the item before invoking lov,i tried to track this in key-listval but all in vain,however key-listval will not fire when user presses the lOV button)
Please suggest in this regard, i want to have this mandatory check at item level itself for all LOV items,
In the application each LOV item contains PRE-TEXT-ITEM ,POST-TEXT-ITEM and WHEN-NEW-ITEM-INSTANCE trigger for follwoing two purposes
1.To decrease and increase field length before and after cursor moves into the LOV item
2.To make the LOV button appear when cursor is in the item and to make it disppear when cursor moves out of the item.
Please suggest me....
Ashish.
[Updated on: Sat, 01 April 2006 03:37] Report message to a moderator |
|
|
|
| Not null check for a LOV item at item level [message #165820 is a reply to message #165692] |
Sun, 02 April 2006 07:58  |
orafaametta
Messages: 11
Registered: March 2005
Location: Hyb
|
Junior Member |
|
|
Hi All,
I am working in a customized database application being devloped using FORMS6i and oracle8i,
the application will be deployed over web.
I have to implement a restriction on all mandatory LOV items in the application,in such a way that as soon as user navigates to other field while keeping that non null LOV item empty,he must be prompted for message and forced to provide a value for the item.
I am achieving this in WHEN-VALIDATE-ITEM trigger for NON LOV items like this
If 'BLOCK_NAME.ITEM_NAME' is null then
Message('Provide the value here');
Message('Provide the value here');
Raise form_trigger_failure;
End if;
IF i write the same code in WHEN-VALIDATE-ITEM for LOV ITEMS,then LOV will not be displyed when cursor(control) is in that LOV item and user presses LOV button. I found that instead of displyig LOV the WHEN-VALIDATE-ITEM trigger fires and raises Form_trigger_Failure with the message 'Provide the value here'
(it seems it is validating the item before invoking lov,i tried to track this in key-listval but all in vain,however key-listval will not fire when user presses the lOV button)
Please suggest in this regard, i want to have this mandatory check at item level itself for all LOV items,
In the application each LOV item contains PRE-TEXT-ITEM ,POST-TEXT-ITEM and WHEN-NEW-ITEM-INSTANCE trigger for follwoing two purposes
1.To decrease and increase field length before and after cursor moves into the LOV item
2.To make the LOV button appear when cursor is in the item and to make it disppear when cursor moves out of the item.
Please suggest me....
Ashish.
|
|
|
|
|
|
|
|
| Re: PLEASE SUGGEST :Not null check for an LOV item at item level [message #165951 is a reply to message #165849] |
Mon, 03 April 2006 10:36 |
orafaametta
Messages: 11
Registered: March 2005
Location: Hyb
|
Junior Member |
|
|
Hi,
I am extremely sorry for reposting the same question as it is a final warning i make sure this will never happen again.
1. Valdiate from List property is YES for all LOV items
2.User is allowed to move the control in LOV button(its always navigable).
(LOV buttons appears and disappears as the control comes-in and leaves the item.)
The mouse navigable property for the LOV button is 'YES', I think this will solve my problem, if I keep this to 'NO'.
Most probably I have got the solutions. I will confirm once I try it in my application
Thanks for the solution
Sorry again for reposting the same text.
Regards,
Ashish.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
