Home » Developer & Programmer » Forms » probelem with radio group population
icon10.gif  probelem with radio group population [message #334032] Tue, 15 July 2008 04:30 Go to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

hello all,

im new to use radio group population,
i have created a form named QNS (PFA)
with 5 database items
questions
opt1
opt2
opt3
opt4.

when im running its working fine.

after that i added radio group then its returning me an error
frm-40505 unable to perform query.

pls help me to over come this problem.




create table scripts
CREATE TABLE ONLINE_PAPERS
(
  PAPER_ID   NUMBER,
  COURSE_ID  NUMBER,
  QUESTIONS  VARCHAR2(100 BYTE),
  OPT1       VARCHAR2(1000 BYTE),
  OPT2       VARCHAR2(1000 BYTE),
  OPT3       VARCHAR2(1000 BYTE),
  OPT4       VARCHAR2(1000 BYTE)
);

ALTER TABLE ONLINE_PAPERS ADD (
  CONSTRAINT PAPER_ID_PK
 PRIMARY KEY
 (PAPER_ID));


ALTER TABLE ONLINE_PAPERS ADD (
  CONSTRAINT COURSE_ID_FK 
 FOREIGN KEY (COURSE_ID) 
 REFERENCES ONLINE_COURSE (COURSE_ID));



insert table scripts
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (1, 1, 'what is 2+3?', '4', '5', 
    '6', '2');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (2, 1, 'what is 2*3?', '4', '6', 
    '5', '2');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (3, 1, 'what is (2*3)+(3*2)?', '20', '10', 
    '12', '24');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (4, 2, 'what is sin90?', '180', '1', 
    '0', '90');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (5, 2, 'what is cos90?', '0', '1', 
    '180', '90');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (6, 2, 'what is tan 45?', '0', '1\2', 
    '1\4', '1');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (9, 3, 'Find the cuberoot of 125?', '2', '5', 
    '3', '6');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (7, 3, 'Find the square root of 121?', '12', '11', 
    '10', '13');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (8, 3, 'Find the square root of 36?', '9', '3', 
    '6', '8');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (10, 4, 'what is your institute name', 'ibm', 'niit', 
    'next', 'aptech');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (11, 4, 'Stray losses in an induction motor generally are ____ .', 'proportional to the square of the stator current', 'proportional to the square of the rotor current', 
    'proportional to the rotor current', 'inversely proportional to the square of rotor current');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (12, 4, 'Which of the following is an AC motor?', 'Synchronous motor', 'Slip ring motor', 
    'Squirrel cage Induction', 'all the above');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (13, 5, 'Which of the following needs to be measured after rewinding of motor?', 'No load current', 'winding resistance', 
    'air gap', 'all the above');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (14, 5, 'Which of the following are ill suited for energy efficient motors application?', 'Punch Presses', 'fans', 
    'pumps', 'all of the above');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (15, 5, 'Unbalance in voltages at motor terminals is caused by ____.', 'Supplying single phase loads disproportionately', 'Use of different sizes of cables', 
    'both a and b', 'none');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (16, 6, 'The efficiency figures for energy efficient motors  can be generally higher by____%.', '3-7%', '10%', 
    '8-10%', '2%');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (17, 6, 'Machine tools are a typical example of', 'Constant power load', 'Constant torque load', 
    ' Variable torque load', 'a and b');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (18, 6, 'The speed of an AC motor depends on ____ .', 'Frequency', 'No. of poles', 
    ' both (a) and (b)', 'None of the above');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (19, 7, 'What determines the thermal loading on the motor?', 'Duty/Load cycle', 'Temperature of the winding', 
    ' Age of the motor', 'Ambient conditions');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (20, 7, 'Which of the following information available on name plate of a motor', 'RPM', 'HP Rating', 
    'Frame Model', 'All the above');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (21, 7, 'Output power requirements of constant torque loads vary with ', 'speed', 'voltage', 
    'current', 'power factor');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (22, 8, 'Five percent increase in supply frequency will change the synchronous speed by ', '-5%', '-9%', 
    '+5%', '-5.5%');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (23, 8, 'Reduction in supply voltage by 10% will change the torque of the motor by ', '20%', '19%', 
    '11%', '19.5%');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (24, 8, 'With decrease in speed of the motor, the required capacitive kVAr', 'Increases', 'Decreases', 
    'Does not change', 'None of the above');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (25, 9, 'The synchronous speed of a motor with 6 poles and operating at 50 Hz frequency is?', '750 ', '1000', 
    '200', '150');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (26, 9, 'The power consumption,in case of centrifugal loads  proportional to', 'speed ', 'square of speed', 
    'cube of speed', 'not applicable');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (27, 9, 'Which types of following motors are most efficient?', 'TEFC', 'SPD', 
    ' Both', 'None');
COMMIT;



thanks in advance.
  • Attachment: QNS.fmb
    (Size: 44.00KB, Downloaded 139 times)
Re: problem with radio group population [message #334056 is a reply to message #334032] Tue, 15 July 2008 06:01 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

hello members,

if u wants to get more information let me know pls. .
i will definitely provide..
since couple of days im running with this error ,,,

regards
seyed
Re: problem with radio group population [message #334079 is a reply to message #334056] Tue, 15 July 2008 06:58 Go to previous messageGo to next message
mandeepmandy
Messages: 79
Registered: May 2008
Location: USA
Member

Set Database property of radio button group to No.Try it and let me know if it wotks
Re: probelem with radio group population [message #334093 is a reply to message #334032] Tue, 15 July 2008 07:35 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

hey mandeepmandy.
thanks for your response.
its still not working after i Set Database property of radio button group to No.


thanks in advance
Re: probelem with radio group population [message #334100 is a reply to message #334093] Tue, 15 July 2008 07:45 Go to previous messageGo to next message
mandeepmandy
Messages: 79
Registered: May 2008
Location: USA
Member

Could you please check what the error message actually?
Goto Help and Display Error on menu
Re: probelem with radio group population [message #334128 is a reply to message #334032] Tue, 15 July 2008 08:46 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

thanks again mandeepmandy..

i dint compile that time i checked it again its working fine..

the datablock i created here for all questions..
but i wanna do it for some specific course..
i have to show the questions only for desired course the user selected.,

can u help me where do i make changes for that? ??
Re: probelem with radio group population [message #334197 is a reply to message #334128] Tue, 15 July 2008 15:34 Go to previous messageGo to next message
mandeepmandy
Messages: 79
Registered: May 2008
Location: USA
Member


Create a list item with all the availale course and let user select one from them and then set dynamically block's WHERE clause using set_block_property to that course before executing query.
Re: probelem with radio group population [message #334276 is a reply to message #334032] Wed, 16 July 2008 01:14 Go to previous messageGo to next message
kvsd_12
Messages: 5
Registered: July 2008
Junior Member
hi i have problem with radio group
please give me solution , actualy when i radio check then i want to save that value in the table.
Re: problem with radio group population [message #334290 is a reply to message #334032] Wed, 16 July 2008 01:53 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

hey mandeep thanks for your response again,.

i created a form named enrollment there i selected course id from user but
where do i make changes to get columns in the questions form ::
questions
opt1
opt2
opt3
opt4

for the desired course id by which user selects.
i hope i have to create a block level trigger but which trigger i can create .

i tried with on-populate trigger but it doesnt works.

can u help me how to achieve this.?.

thanks in advance .

Re: problem with radio group population [message #339143 is a reply to message #334290] Wed, 06 August 2008 21:30 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What are you trying to do?

David
Previous Topic: how to change tab canvas direction in 10g
Next Topic: Newbie, forms builder 6i and 10G?
Goto Forum:
  


Current Time: Tue Dec 06 12:23:23 CST 2016

Total time taken to generate the page: 0.11196 seconds