<div>
<blockquote>
 Do not use navigational triggers (including: pre-text-item, post-text-item, key-next-item, key-previous-item, etc.) to change database items
</blockquote>
<br />
but in same last quation you adviced me to use key_next_item<br />
<a href="https://www.experts-exchange.com/questions/28463857/Query-record-if-it-is-exist.html?anchorAnswerId=40218110#a40218110" rel="ugc">https://www.experts-exchange.com/questions/28463857/Query-record-if-it-is-exist.html?anchorAnswerId=40218110#a40218110</a>
</div>


> 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
https://www.experts-exchange.com/questions/28463857/Query-record-if-it-is-exist.html?anchorAnswerId=40218110#a40218110 [https://www.experts-exchange.com/questions/28463857/Query-record-if-it-is-exist.html?anchorAnswerId=40218110#a40218110]

<div>
after investigating all codes , i found that i have wrong updating of one database item<br />
under po_query of the form<br />
it is ok now<br />
thanx markger
</div>


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

<div>
Yes, a key-next-item trigger is a good option to use for some problems in some forms. &nbsp;But like most tools, a key-next-item trigger in Oracle Forms has advantages and disadvantages.
</div>


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.

<div>
<div class="content wysiwyg-content">
please see the solution of markgeer here<br />
<a href="https://www.experts-exchange.com/questions/28463857/Query-record-if-it-is-exist.html" rel="ugc">https://www.experts-exchange.com/questions/28463857/Query-record-if-it-is-exist.html</a><br />
<br />
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 ?<br />
i think it speaking about the 2 non_databse items which they filled by value
</div>
</div>


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

Clear non_database items After Query

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.