OraFAQ Forum: Forms » Regarding a form

Home » Developer & Programmer » Forms » Regarding a form

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

Regarding a form [message #199621]

Wed, 25 October 2006 04:49

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?

Report message to a moderator

Re: Regarding a form [message #199710 is a reply to message #199621]

Wed, 25 October 2006 23:35

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: Regarding a form [message #199770 is a reply to message #199621]

Thu, 26 October 2006 03:10

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

Report message to a moderator

Re: Regarding a form [message #199915 is a reply to message #199770]

Thu, 26 October 2006 18:12

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

@Bhujendra - I suggest adding a 'raise form_trigger_failure' to stop the commit.

David

Report message to a moderator

Re: Regarding a form [message #199920 is a reply to message #199770]

Thu, 26 October 2006 23:07

kbhujendra@rediffmail.com
Messages: 26
Registered: June 2006
Location: Hyderabad,India

Junior Member

Thanks for the update David.

Report message to a moderator

Previous Topic:	"Open File Dialog box" in 10g suit forms
Next Topic:	cursor style

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 06:42:16 CST 2025