| Helep needed on radia buttons [message #305443] |
Mon, 10 March 2008 15:26  |
syedalisajjad
Messages: 8
Registered: March 2008
|
Junior Member |
|
|
AOA i m doing my final project and i m using Oracle 11g and Developer 10g! i want to know few things! it shall be very nice of u if u can help me and i shall be very thankful to u!
1. I want to make a questionnairre and add five radio buttons after every question for the answer.
I have put 4 radio buttons in one group and assigned them the values 5,4,3,2,1 respectively. 5 for excellent,4 for v good and so on.
Can u please tell me the code to store the value of those radio buttons in the column of a table let's suppose we have a table called answers and the value of radio button has to be stored in column of a table answers.
i want to put 15 questions on the questionnairre and i want that after giving the feed back when user clicks on submit all the values are stored to the respective column of that table! please do help if u can
thanks!
sample form is attatched please chk out!
-
Attachment: model.fmb
(Size: 52.00KB, Downloaded 965 times)
|
|
|
|
| Re: Helep needed on radia buttons [message #305707 is a reply to message #305443] |
Tue, 11 March 2008 11:30  |
magnetic
Messages: 324
Registered: January 2003
|
Senior Member |
|
|
create tablt t -- to store answers
(xuser varchar2(20) -- store the username in it
,c number(10) -- id of the question
,c1 number (2) -- radio value of choise
);
create radiogroup "answers" with choises
each radio has a value in the properties, set the desired value of each radio.
create when-radio-changed trigger with code:
-- function call to check the exsistance of the answer in table t, if no then do a insert else a update
insert into t values(user
,:blockname.question_id
,:blockname.answers);
commit
-- user can switch choises, then you should do a update
update t
set xuser=user
, c = :blockname.question_id
, c1= :blockname.answers;
commit;
----
now after commit, you can show the view of the next question in case you interact like a wizard or the users makes the choise of the second question in case questions are on the same canvas.
table t contains as much records for the users as there are questions.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
