Forms :: How To Track Radio Button ID Or Name In Oracle
Jun 27, 2010
I have a form which contains some block (each block with some text item, two radio groups and a list item). I want to enable/disable and set visible property as true/false for first to last items of each block conditionally. I can do that for all items but radio buttons.
Because to set item or radio button property I need to pass that items ID or Name as parameter. I can get items name/type using get_block_property and next item of that item using get_item_property but unable to get radio button ID/Name using get_radio_button_property or any other built in. To execute get_radio_button_property or set_radio_button_property I need to pass radio button ID/Name. So, how I track radio button id or name in oracle forms? Is it limitations of Oracle forms?
I have one interface form where user will choose radio buttons and based on radio button value different report will run, in one radio button i want to check parameters , for example if there are three radio buttons, a - will run a.rdf ,b- will directly run b.rdf , if user chooses c - then prompt will appear asking him to input from date and to date and based on that value c.rdf will run.
I want this date parameters to run only for this report c.rdf only.One way is to display from date and to date on forms and make it applicable to only this report , but i want to use this parameters only while choose c radio button.
I am working on forms 10g(version 10.1.2.0.2 ) with Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 on windows 2000 platform. My requirement is to dynamically get the label of the radio button item in a radio group.I am able to get the label of the radio group as shown below
Item :Radio group Label : Gender
IF m_type = 'RADIO GROUP' THEN m_label:=Get_Item_Property(m_Item ,label); END IF;
There two Radio buttons inside this radio group which are item : Radio button Label : Male
item :Radio button Label :female
What is the code to get the label of radio button(i.e) male and female ?
How will I get the count of radio buttons in a radio group at runtime?
i have 2 radio button on my forms and values are A and B. But i have load data from script and against that radio button i have some other values loaded,
When i select query on those records those have other value then radio button, it show nothing. I want to catch that error but there is no error shows. it shows no record to be query. i just want to inform user that that record is not that value which is associated with radio.
i have field in DB that taken ( 1 or 2 or 3 ) am added it as text item at first and then change it to ( radio group ) contain 3 radio as :
value for first 1 = 1 , = 2 , = 3 and mapping = 1 initial value for the group = 1
but when am working with the form and commit form there is no data add in this field when am change the radio value by click on any other on ( 2 or 3 ) it's saved no problem in it ..
why this thing happen coz i need to set the first radio as default for the form .
Suppose There are Four options in a Radio Group. From this whichever option I select using the Mouse that option must be Inserted in the Database table field.
How to do this Using Radio Buttons.
Also If I want to select more than One Option Then I use Check Box. For this Also When I select two or three options simultaneously then these values must be Inserted in the Database Table Fields.
how can i get the chosen value in radio button into text item which is in another form?
Suppose i have 3 radio buttons (watch, gadget and jewelry)then I choose watch.How can i display that chosen radio button into the text item which is in another form?
i have a radio group(RG) in that group i have two radiobuttons: rb1 and rb2 on a datablock based on a view having display iems 8. i made only one visible i.e rb1. so there is 8 radio buttons displaying in that datablock and when i check one and then another, the previously checked is not unchecked by itself. i need to do when i checked on one then the previous one unchecked itself.
i have used radio button under dynamic conditions for an interactive report.eg: radio button values are like a) front end b)middlware c)back end.so based on the selected value of the radio button, interactive report appears. and each fields in radio button have separate set of users. now my issue is,based on the user logging in, the default value should set up while the page is loaded...[i.e... if a front end user logs in, the default value of tat radio button shd be front end...]
I have a page with about 8 Classic reports. 4 of them percentage values, 4 totals. I have one RG with a Percentage or total option. When I select the percentage radio, it should hide all the total regions. When I select the totals radio it should hide all the percentage regions. Simple? So I thought. This is what I did.
1. Created a RG(P2_RG) -> Page value is redirect and set value.
2. STATIC:Percentage;P,Total;T
In the RG, I have created a normal DA which has the true and false events as follows.
Event -> Change Items -> P2_RG equal to -> P
In the true actions, I have hidden the 4 totals regions. shown the 4 Percent regions. In the false action, I have shown hidden the 4 percent region shown the 4 totals region.
The event specification for one these true actions is
Action -> Hide (If I am hiding) Fire when event is ->True Selection type -> region Region -> The region I want to hide/show.
But it does not work! I tried to replicate the issue on apex, by using a small example but could not. Works fine in apex following the same process.
[URL]
I tried to debug by having a display item to show the value when I change the radio button. The values are changing properly. I tried actually, adding a condition filter in the region itself by using the "Value of item/column in expression1 = expression 2" where expression one I tried :P2_RG and expression 2 as P but that just hides the whole region.
I have a trigger program to track updated information's on perks column. I am failing to finish systime in my trigger program.
SQL> desc user_track; Name Null? Type ----------------------------------------- -------- ---------------------------- EID NUMBER ENAME VARCHAR2(15) OLD_PERKS NUMBER NEW_PERKS NUMBER UNAME VARCHAR2(15) ACTION_DATE DATE ACTION_TIME DATE
SQL> create or replace trigger tri_track 2 After UPDATE ON EMP 3 FOR EACH ROW 4 BEGIN 5 insert into user_track(EID,ENAME,OLD_PERKS,NEW_PERKS ,UNAME,ACTION_DATE,ACTION_TME) values 6 (:old.eid, :old.ename , :old.perks, :new.perks,user, sysdate, to_char(sysdate , 'HH24:MI:SS') 7 from dual; 8 end; 9 /
I have three blocks in my form , header,activity and item.One header can have many activities and one activity can have many items.I need to keep track of item value totals in header from items under each activity.
My requirement is I have placed a check Box in the Detailed Block and i have assigned values for the check box as
Checked - R Unchecked - P Initial Value - R
by default the check box would be displayed as Checked while inserting the values in to table the value of check box is not getting inserted but when the check box is unchecked the the value is getting inserted as P when the submit button is pressed.
I have a Radio Box Item field in Form, It contain Three Radio Buttons.
During the User Login Some of the users Not Require to Touch Any of the Three Radio. Thus i Require to Disable that Radio Button to That User. How to Disable the Particular Radio Button.
i've created an alert with 2 buttons and the code for cancel button is as follows:
... if alert_id = alert_button2 then raise form_trigger_failure; end if; ...
this code is in a pll and when called from a form it displays a non oracle exception message. How to do nothing when the user presses cancel on alert pop-up? apart from using null instead of raising the above exception?
just i want to ask about access key property for button..i'm using oracle forms 10g ,
suppose that i have 3 buttons in a module like the following:
1- buttonOne --access key property for this button is "1" 2- buttonTwo --access key property for this button is "2" 3- buttonThree --access key property for this button is "3"
when run this module then the user press "1" the trigger when-button-pressed not fire until he press Alt+1...how the user can press the "1" only to fire the trigger when-button-pressed? just like form 6i?
For passing my apprenticeship I am developing part of an application to change the language of the application dynamically.
My first idea looks like this:
In each form I add a package that works like this:
block := first block loop ..item := first item ..loop ....set item label or prompt to new language ....exit when item = last item ....item := next item ..end loop
..exit when block = last block ..block := next block end loop
That far everything is fine. With the get_form_property I can access the first and last block and always get the next block with the get_block_property. Same is true for the items by get_block_property for the first and last item and the get_item_property for the next item. By this way I can dynamically chance all item prompts and labels without knowing the name or the number of blocks and items. But what about radio groups? Is there any possibility (and if yes, which?) to get the first, last and next radio button of a radio group in the same way?
i want to get the x-pos of item at the radio-change trigger but it return the error
declare x_pos number; lnum_x_pos number; lnum_width number; begin
if :radio_group = 'E' then lnum_x_pos := Get_item_property('Remarks',x_pos); Message('Position of x...'||lnum_x_pos); lnum_width := get_item_property('Remarks',width); Message('width of remarks field..'||lnum_width);
I have a query form where I am attempting to add radio buttons for the user to specify if they want to see Active, Expired, or Both vendors. The existing form is a multirow database block and a single-row detail database block. Users query in the multirow block. I created a QRY_CONTROL non-database block with the radio group and a couple other variables. When they select a radio button, the WHEN-RADIO-CHANGED changes the default block's where clause.
My problem is that the radio buttons cannot be changed in ENTER-QUERY mode. If they cancel the query, the buttons work as expected. I put in a couple messages and the trigger isn't even firing, so I ruled out a code problem I think.I checked to make sure that the group properties are Enabled=true, mouse_navigable=true, query_allowed=true.
I am trying to track an employee's department changes by adding a Department change counter which is set to 1 whenever the department changes otherwise it is set to a 0. How can I accomplish this update of the counter? Below is the table creation sql and sample data for insert.
CREATE TABLE EMPL_DEPT (EMPLID VARCHAR2(11) NOT NULL, EFFDT DATE, EFFSEQ SMALLINT NOT NULL, EMPL_RCD SMALLINT NOT NULL, DEPT_ID VARCHAR2(12) NOT NULL, [code]..........
i want do add a image as a button.i added iconic image on a button from desktop,but its not working during runtime,i only see a flat button instead of iconic..what should i do...??
I hava LOV and i want process events when click button Cancle on LOV then disable a canvas, but i don't know how process it.where could know events click mouse in button Cancle on LOV - Oracle Forms?
we have a database application which is done frequently.in these we load data throught Sql loader, we create an DB instances, we do several DML operation on the database.
now for such task in an application we need to keep an logging track of each task performed in PL/SQl procedure packages.
In our architecture, the application can only access functions/procedures to access/modify data. Each function logs the action, the executed sql statement, oracle error, user terminal, and the user into a unified log table by using v$ tables to create a general log function that is called after execution or error.
The only advantage is that it will be easier to know the delete and last update information faster versus space and design modification.
