Home » Developer & Programmer » Forms » Regarding a form
Regarding a form [message #199621] Wed, 25 October 2006 04:49 Go to next message
orafan2003
Messages: 122
Registered: February 2006
Senior Member
Hi,
In my form,
there is one block based on a table. There are 10 columns in my table. When I run my form, and enter values and press a button, the values will be saved in the database. Even without entering any values and pressing the button is submitting null values into the table. I want the user to enter values in 5 text item compulsorily. I tried using "required" property. But that property is working only if the focus is in that particular text item. How can I achieve this task of making the user enter values even if the focus is not in that particular text-item?
Re: Regarding a form [message #199710 is a reply to message #199621] Wed, 25 October 2006 23:35 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Write a When-Validate-Record trigger to test the fields and tell the user that 'not all mandatory fields have been entered'.

David
Re: Regarding a form [message #199770 is a reply to message #199621] Thu, 26 October 2006 03:10 Go to previous messageGo to next message
kbhujendra@rediffmail.com
Messages: 26
Registered: June 2006
Location: Hyderabad,India
Junior Member

Hi,

Do simply like

In Key-Commit trigger:

If :block.text_item1 is null or
        :block.text_item2 is null or
         ... Then
     Message('Fields must be entered');
     End If;



Thanks,
Bhujendra
Re: Regarding a form [message #199915 is a reply to message #199770] Thu, 26 October 2006 18:12 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
@Bhujendra - I suggest adding a 'raise form_trigger_failure' to stop the commit.

David
Re: Regarding a form [message #199920 is a reply to message #199770] Thu, 26 October 2006 23:07 Go to previous message
kbhujendra@rediffmail.com
Messages: 26
Registered: June 2006
Location: Hyderabad,India
Junior Member

Thanks for the update David.
Previous Topic: "Open File Dialog box" in 10g suit forms
Next Topic: cursor style
Goto Forum:
  


Current Time: Sat Dec 10 11:00:20 CST 2016

Total time taken to generate the page: 0.07999 seconds