OraFAQ Forum: Forms » On query_execute which triggers will file

Home » Developer & Programmer » Forms » On query_execute which triggers will file

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

On query_execute which triggers will file [message #280055]

Mon, 12 November 2007 06:55

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.

Report message to a moderator

Re: On query_execute which triggers will file [message #280058 is a reply to message #280055]

Mon, 12 November 2007 07:00

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: On query_execute which triggers will file [message #280068 is a reply to message #280055]

Mon, 12 November 2007 07:11

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

Littlefoot
Messages: 21823
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).

Report message to a moderator

Previous Topic:	Manipulating Files in Oracle Forms
Next Topic:	Can we connect Forms 6i with Sql server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 20:39:39 CST 2025