Home » Developer & Programmer » Forms » Helep needed on radia buttons (Oracle Developer 10g)
Helep needed on radia buttons [message #305443] Mon, 10 March 2008 15:26 Go to next message
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 163 times)
Re: Helep needed on radia buttons [message #305707 is a reply to message #305443] Tue, 11 March 2008 11:30 Go to previous message
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.


Previous Topic: changing foreground color of rectangle or rounded rectangle at runtime
Next Topic: Control block : is must?
Goto Forum:
  


Current Time: Tue Dec 06 11:57:04 CST 2016

Total time taken to generate the page: 0.10241 seconds