Skip to Main Content
Forums

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

About Free Navigation in data block's Item

639858Sep 11 2008 — edited Sep 11 2008
Hello every one.

I'm using Forms 9i and oracle 9i database.

Case : I'm making a form in which table i'm using having all fields declared as NOT NULL
in forms required property of each item is set to yes.

After running the form i can't navigate within the fields unless theres something entered in it.

i tried setting the required property to no it makes navigation but it don't check for empty fields then and error comes only after it is posted to database.

what i wish it to be like i can freely navigate in fields taking care that they are declared not null in database
and that i can stop sending the data to database if any of them is left empty
This post has been answered by Tony Garabedian on Sep 11 2008
Jump to Answer

Comments

easot-tech
Check your "Defer Required Enforcement" property on the form.
1 person found this helpful
Tony Garabedian
Answer
you have 3 options with "Defer Required Enforcement" "Yes", "No" and "4.5"

No is the default.

If set to "Yes" the Enforcement will take place upon committing of the form and the you can move freely within the items. But in this case WHEN-VALIDATE-ITEM triggers will not fire until saving the form.

If set to "4.5" you will be able to navigate freely AND the WHEN-VALIDATE-ITEM triggers will fire when the item is validate even if the item is empty. This will be useful if you have calculations that you need to perform.


Tony
Marked as Answer by 639858 · Sep 27 2020
639858
Thank you very much it solved my Query Although i have not checked but i know it will work . Thank you all.
Tony Garabedian
You're welcome.

It will work, We use 4.5 in our application and it works like magic.
639858
Can i chat with you online , have some more problem but no one to discuss with. if its possible then please. my id is " rainbow99984@gmail.com"
thank you.
Tony Garabedian
Unfortunately I cannot use webmail from my current connection.
If you have other questions, you can ask them here by creating new threads, and i'll try to answer them as much as I can.


Tony
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 9 2008
Added on Sep 11 2008
#form, #forms, #moved-from-devops
6 comments
387 views