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
NiceMan331Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.