Solved

Clear non_database items After Query

Posted on 2014-09-04
4
378 Views
Last Modified: 2014-09-10
please see the solution of markgeer here
http://www.experts-exchange.com/Database/Oracle/Q_28463857.html

the code works well , but i have one issue , after the record query and want to to exit the form or query another record , it send me message : you want to save changes ?
i think it speaking about the 2 non_databse items which they filled by value
0
Comment
Question by:NiceMan331
  • 2
  • 2
4 Comments
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 500 total points
ID: 40305746
No, this message in Oracle Forms is *NOT* caused by values in non-database items.  This message is related to changes of dataabse items in the form.  This happens when either:
1. the user changed a value in a database item (but did not press "Save")
2. a form trigger changed a value in a database item

To avoid this message (when you don't expect it):
1. Do not allow a post-query trigger to change database items
2. Do not use navigational triggers (including: pre-text-item, post-text-item, key-next-item, key-previous-item, etc.) to change database items
0
 

Author Comment

by:NiceMan331
ID: 40307233
Do not use navigational triggers (including: pre-text-item, post-text-item, key-next-item, key-previous-item, etc.) to change database items

but in same last quation you adviced me to use key_next_item
http://www.experts-exchange.com/Database/Oracle/Q_28463857.html#a40218110
0
 

Author Comment

by:NiceMan331
ID: 40314088
after investigating all codes , i found that i have wrong updating of one database item
under po_query of the form
it is ok now
thanx markger
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 40314464
Yes, a key-next-item trigger is a good option to use for some problems in some forms.  But like most tools, a key-next-item trigger in Oracle Forms has advantages and disadvantages.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
help on oracle query 5 53
PL/SQL Display based on value 4 39
form builder not starting 3 55
PL/SQl Expanding the WHERE statement in query 3 18
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question