Home » Developer & Programmer » Forms » On query_execute which triggers will file
On query_execute which triggers will file [message #280055] Mon, 12 November 2007 06:55 Go to next message
syed_hussain
Messages: 6
Registered: November 2007
Location: India
Junior Member
Based on two radio buttons,i am populating some fields, i.e. if first radio button is selected then some fields are making displayed and populating some values and if other radio button is selected then some other fields are making displayed and populating some values.

If i do query_execute then those two radio buttons fields are not at all displaying.


Plz tell me which triggers will fire on query_execute so that based on the record some fields has to be populated.
Re: On query_execute which triggers will file [message #280058 is a reply to message #280055] Mon, 12 November 2007 07:00 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Are those radio buttons database columns? If not, EXECUTE_QUERY has no enough information to know which fields should be displayed/populated and how.

By the way, and although it is not the question, use the POST-QUERY trigger to populate non-database fields after executing a query.
Re: On query_execute which triggers will file [message #280068 is a reply to message #280055] Mon, 12 November 2007 07:11 Go to previous messageGo to next message
syed_hussain
Messages: 6
Registered: November 2007
Location: India
Junior Member
yes,these radio buttons are database items.I am using the post query trigger and in that set_item_property code i have written.
like this.here though the customer_type is 0 or 1.It is firing only once and and the fields aare not at all changing(on/off).

if :xxaon.customer_type=1 then
   set_item_property('XXAON.INVOICE_ADDRESS2',
   ISPLAYED, PROPERTY_ON);
   app_item_property.set_property('XXAON.POSTAL_CODE',
   DISPLAYED, PROPERTY_ON);
   set_item_property'XXAON.CITY',
   DISPLAYED, PROPERTY_ON);
elsif :xxaon.customer_type=0 then
   set_item_property('XXAON.INVOICE_ADDRESS2',
   ISPLAYED, PROPERTY_OFF);
   app_item_property.set_property('XXAON.POSTAL_CODE',
   DISPLAYED, PROPERTY_OFF);
   set_item_property'XXAON.CITY',
   DISPLAYED, PROPERTY_OFF);
end if;



then it is populating any fields.

[EDITED by LF: added [code] tags]

[Updated on: Mon, 12 November 2007 07:35] by Moderator

Report message to a moderator

Re: On query_execute which triggers will file [message #280086 is a reply to message #280068] Mon, 12 November 2007 07:42 Go to previous message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What are "xxaon" and "customer_type" in ":xxaon.customer_type"? Radio buttons? "xxaon" should be block name, and "customer_type" radio group name (not radio button item name).

Also, you might test what's in there by displaying a message:
message('xxaon.customer_type = ' || :xxaon.customer_Type);
so that you'd know what is, actually, going on (or, alternatively, put a message into the trigger you've posted in your previous message).
Previous Topic: Manipulating Files in Oracle Forms
Next Topic: Can we connect Forms 6i with Sql server
Goto Forum:
  


Current Time: Mon Dec 05 21:15:53 CST 2016

Total time taken to generate the page: 0.07222 seconds