My friends,

I have a FORM with a List of Questions, where each one has 3 Radio Buttons aside, with Radio values : 3,2,1.
TheUser has to select one of those Radio buttons for each Question.

//I have 10 questions.

At the end of the FORM, I have a SAVE Button, which first has to check if all the Questions have been selected by the User (if not, I have to show an alert, telling the
user, which Question(s), he didnt choose one of the RADIO buttons of it)
If all the questions have been choosed, then save the RADIO_GROUP VALUES, for each question into the related table in DB.
example:
Question 1: 5-3 equals to ? 3@ 2 @ 1@
where, at 3,2 and 1 we have Radio
Buttons, assigned those values to them.
And for question 1, I have RADIO_GROUP1, which I initially assigned to it the value 0, the same as a hidden Radio Button I added into the Form.

Can you show me, how can I do the trigger(s) for this case
Do I have to put a trigger at each Radio Group (each question) WHEN-RADIO-CHANGED
and If I do put this trigger, how can I use it.
OR I just Have to put a trigger, WHEN-BUTTON-PRESSED
at the SAVE button, in which I can check each RADIO_GROUPX, if its value is still ZERO (the initiall one), case which it means, that question has not been checked.
Another question, if you do not mind:
When the User, clicks at one of the Radio Buttons for a question, does that button value (assigned to it) is passed directlly into the RADIO_GROUP.
What if the User Cancels the procces?
//Anny detailed information on how to use Radio Buttons will be usefull



Please, Help me ,
I appreciate your time and effort.
THNX

Hi..
1) create your radio button group(let's call it multiple_answer)
2) create 3 radio buttons named 1,2,3 and have the value property 1,2,3 respectively.
 and the property visible = Yes to all of them.
3) create another radio button named null_value and let the value property null for it.
and  the property visible = No .
i mean by null that you leave it blank.
4) for the radio group (multiple_answer),set the initial value property to null.
,mapping of other values to null too.
This will create the radio buttons 1,2,3 on your form and no answer is selected when
you enter the question.
And if the user answers the question (select 1 for example),
the field multiple answer will hold this value,otherwise..if he 
did not answer the question,it's value will be null.

5) you can create (next,back) buttons on your form if you
are viewing one question at atime so the user can navigate throw questions
and on the when-button-pressed trigger commit the changes :
commit;  --this will save the answer (1,2 or 3) into multiple_answer field.
or if you are viewing multiple questions at atime,then you can save the answer by atrigger
called when-radio-changed:
commit;

5)if you want to create a save button to tell the user which questions he did not answer,then
i think you can get the unanswered questions (multiple_answer is null)
and view them using acursor.

i don't think this is enough..but this may give you an idea.
good luck.  

تم تعديل 13 أبريل 200619 سنة بواسطة ammar_kh1982

Bro. ammar_kh1982

First THNNXXXX a lot , for your time & information.
You'r right, that' gave me an idea. Now I have to see how to get the unanswered questions
and view them using acursor (as you suggested).

By the way, If the User presses the CANCEL button (or does exit the Form), is anny thing saved into the DB, ....do I need to use Roll_back ....or actually no thing is saved no where.

THNXXX agin


Alban