About Free Navigation in data block's Item
639858Sep 11 2008 — edited Sep 11 2008Hello 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