OraFAQ Forum: Forms » Conflict of POST-QUERY trigger with LOVs with Validate from List Propoerty

Home » Developer & Programmer » Forms » Conflict of POST-QUERY trigger with LOVs with Validate from List Propoerty (Oracle forms 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Conflict of POST-QUERY trigger with LOVs with Validate from List Propoerty [message #685727]

Tue, 15 March 2022 06:43

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

Report message to a moderator

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

Littlefoot
Messages: 21781
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);

Report message to a moderator

Previous Topic:	disable button after press (Prevent multi click)
Next Topic:	run 10g form on mobile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 23 10:42:11 CDT 2023