Home » Developer & Programmer » Forms » Conflict of POST-QUERY trigger with LOVs with Validate from List Propoerty (Oracle forms 10g)
Conflict of POST-QUERY trigger with LOVs with Validate from List Propoerty [message #685727] Tue, 15 March 2022 06:43 Go to next message
Imran.Younis
Messages: 1
Registered: March 2022
Junior Member
Hi Gurus,

I have a problem where I am populating some non-database items after querying the block in (POST-QUERY at Block level) and that non-database item has "Validate from List" property as "Yes" and due to this "YES" property it changes some database items too. So my :SYSTEM.MODE is "CHANGED" due to this reason and form asks "Do you want to commit the changes you have made" while exiting the form without any manual changes.

Do you guys have similar problem? What is the possible solution to this issue?

I don't want to set property "Validated from List" of non-database item as "No"
And POST-QUERY trigger is mandatory to populate non-database items via query.

Regards,
Imran Younis
Re: Conflict of POST-QUERY trigger with LOVs with Validate from List Propoerty [message #685774 is a reply to message #685727] Tue, 22 March 2022 08:58 Go to previous message
Littlefoot
Messages: 21736
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Put this to the end of the POST-QUERY trigger:

set_record_property(:system.trigger_record, 'BLOCK_NAME_GOES_HERE', status, query_status);
Previous Topic: disable button after press (Prevent multi click)
Next Topic: run 10g form on mobile
Goto Forum:
  


Current Time: Mon Aug 08 05:10:57 CDT 2022