Welcome to Dream.In.Code
Become an Expert!

Join 150,222 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 2,212 people online right now. Registration is fast and FREE... Join Now!




Oracle Forms 6i EXIT_FORM not behaving as expected

 
Reply to this topicStart new topic

Oracle Forms 6i EXIT_FORM not behaving as expected, Form won't close due to blank field

amos
23 Nov, 2007 - 01:38 AM
Post #1

D.I.C Head
**

Joined: 16 Apr, 2005
Posts: 142


My Contributions
Hi All

I've got a basic Form for adding a new record, checking an old one or updating it. I've put an Exit button on the form, so that I can just click on it and return to the previous window without making any changes.

The button has the following code attached:

CODE

WHEN-BUTTON-PRESSED
BEGIN
    EXIT_FORM(NO_VALIDATE, NO_COMMIT);
END;


If I open up the form but don't run a query (in other words leave all of the fields blank) and click on the Exit button I get the following error message:

CODE
FRM-40202: Field must be entered


I've tried various permutations of things, all I want the button to do is close the form without saving anything.

Cheers
Amos biggrin.gif
User is offlineProfile CardPM
+Quote Post

amos
RE: Oracle Forms 6i EXIT_FORM Not Behaving As Expected
23 Nov, 2007 - 02:31 AM
Post #2

D.I.C Head
**

Joined: 16 Apr, 2005
Posts: 142


My Contributions
It appears to be linked to the first field (my Primary Key) as long as this has a value in it, then I can exit the form.

Anyone got any ideas?

Cheers
Amos

This post has been edited by amos: 23 Nov, 2007 - 02:31 AM
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 1/9/09 05:50AM

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month