• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

Clear non_database items After Query

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
NiceMan331
Asked:
NiceMan331
  • 2
  • 2
1 Solution
 
Mark GeerlingsDatabase AdministratorCommented:
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
 
NiceMan331Author Commented:
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
 
NiceMan331Author Commented:
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
 
Mark GeerlingsDatabase AdministratorCommented:
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now