Forms 6.0- how do I set values for a radio button?

I have two tables

MASTER1
 account varchar2(10)
 name    varchar2(3)

DETAIL1
 account varchar2(10
 account_type varchar2(1)


Also have 3 radio buttons together in one radio group.

WHAT I WANT TO DO:

user queries a MASTER1 record.
then it gets the matching DEATIL1 record.
then if account_type = 'A', it sets radio_button1 to 'on'
     if account_type = 'B', it sets radio_button2 to 'on'
     if account_type = 'C', it sets radio_button3 to 'ON'

QUESTION: what is the trigger or sub_program i need ot use to do this?
joekeriAsked:
Who is Participating?
 
kenshireyConnect With a Mentor Commented:
user queries a MASTER1 record.
then it gets the matching DEATIL1 record.
then if account_type = 'A', it sets radio_button1 to 'on'
    if account_type = 'B', it sets radio_button2 to 'on'
    if account_type = 'C', it sets radio_button3 to 'ON'

CASE 1:
Your radio group is BOUND to a database column (probably called "account_type"
--------------------------------------------------------

Your radio buttons will AUTOMATICALLY set themselves.



CASE 2:
Your radio group is UNBOUND, and you wish to manually control them.  Let's assume you're doing query-only processing at this point.
--------------------------------------------------------
Step 1:

Ensure that the individual buttons in the group have the same values as the database column,eg: 'A' for the database column value 'A', and ensure that the group is set to accept character data.

In a post-query trigger of the Detail1 block, put this code:

  BEGIN
    -- Don't do any processing here that requires saving the results to the database.
    :DETAIL1.MyRadioGroup := :DETAIL1.ACCOUNT_TYPE;
    -- we've just dirtied the record, and Oracle will try to update the database record.  Fix this below
    SET_RECORD_PROPERTY(:SYSTEM.CURRENT_RECORD,'DETAIL1',STATUS,'QUERY_STATUS');
 -- Do any other processing which dirties the record and requires changes to be saved below:


  END;


0
 
schwertnerCommented:
I think you can assign to the radio button item the value appropriate to the needed buton state.
0
 
joekeriAuthor Commented:
HWO DO I DO THAT?
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
joekendallCommented:
Here is the syntax needed:

set_item_property('BUT_LOGON',enabled, property_true);

'BUT_LOGON' is the name of the button

Thanks!

Joe
0
 
joekeriAuthor Commented:
i USED THE set_item_property


BUT WHAT i AM NOT CLEAR ON  IS:



What trigger do I need to use

in which block (MASTER1 or DETAIL1) do i insert the trigger.
0
 
joekendallCommented:
Which block has the account_type? Which block has the buttons?

Thanks!

Joe
0
 
vanmeerendonkCommented:
Try the POST-QUERY and WHEN-VALIDATE-ITEM (or record) on DETAIL1
0
 
joekeriAuthor Commented:
Account_type is located in the DETAIL1 block. An dthat is where i Have placed my RADIO Group as well.
0
 
joekeriAuthor Commented:
by changing the SET_RECORD_PROPERTY from what you described, to:

SET_RECORD_PROPERTY(1,'DETAIL1',STATUS,QUERY_STATUS);


NOTICE the use of a record number and removal of the quotes around QUERY_STATUS.

This now works the way i wanted it to..

Thank you for you help
0
 
joekeriAuthor Commented:
i had to put in 1 for the record number and remove the quotes aroudn QUERY_STATUS to get it to work.


Thanks for you help.
0
 
joekeriAuthor Commented:
your set_record_properrty worked. All I had to do was put in 1 for teh record # and remove the quotes aroudn QUESRY_STATUS.


thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.