Home » Developer & Programmer » Forms » FORM 6i Requirement (Oracle Forms 6i, Windows)
FORM 6i Requirement [message #511267] Fri, 10 June 2011 11:28 Go to next message
praveenkumar2408
Messages: 5
Registered: April 2011
Junior Member
Dear Experts,
I have a form with fields like, UserName, User ID Email Address. This is used to create new users & edit existing user information. I wanted to make the Email field mandatory. So i made the email field as 'Required' via Proerty Pallette. So when ever i create new users after this change, i get a message saying 'Field must be required' when i try to skip this email field.

However when i edit existing user information and try to save the data with no email address i am able to save. So can you please assit me, where when i try to save a user info with no email address, i should get a warning saying 'email address is required'. How to go about it and if i wil have to create any trigger.
Praveen
Re: FORM 6i Requirement [message #511277 is a reply to message #511267] Fri, 10 June 2011 12:26 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
put a when-validate-item trigger instead.
or, are you spacing over the data and thinking it is blank?
you really haven't given a good enough description of what you did.
Re: FORM 6i Requirement [message #511298 is a reply to message #511277] Fri, 10 June 2011 23:18 Go to previous messageGo to next message
mrnaveed
Messages: 74
Registered: December 2009
Location: Pakistan
Member
You can do one operation at a time it is not possible to do both operation at a time.
Re: FORM 6i Requirement [message #511310 is a reply to message #511298] Sat, 11 June 2011 04:15 Go to previous messageGo to next message
cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester
Senior Member
What operations are you talking about?
Re: FORM 6i Requirement [message #512490 is a reply to message #511267] Mon, 20 June 2011 12:33 Go to previous messageGo to next message
praveenkumar2408
Messages: 5
Registered: April 2011
Junior Member
When ever i update Username, i should get a message saying, 'Email address is required'. Can you please assist how can i make this happen. As i am new to oracle forms, if you can can you help me a example/syntax.
Re: FORM 6i Requirement [message #512524 is a reply to message #512490] Mon, 20 June 2011 16:46 Go to previous message
cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester
Senior Member
Setting the required property to Yes is all that should be needed. If it doesn't work then you've done something odd in the form to stop it.
Previous Topic: LOV
Next Topic: Forms 10g Global Variable
Goto Forum:
  


Current Time: Sat Sep 07 16:07:21 CDT 2024