Solved

Clear non_database items After Query

Posted on 2014-09-04
4
370 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Difference in number of minutes between 2 timestamps 16 52
Queries 15 38
Oracle - SQL Query with Function 3 35
Email query results in HTML 6 18
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

773 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