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 some doubts about Radio buttons,
1) how to validate radio buttons in WHEN-RADIO-CHANGED?
2) how to disable a radio button?
3) how to disable a text item when a radio button is un-checked.
4) how to assign default value to radio button like(1,2,3...) or(A,B,CD,...)
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 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 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?
When i open the form,select a radio button and immediately do a SHIFT+TAB form hangs.
After selecting the radio button if i do a TAB and then do shift+tab it works fine for me.
There is no KEY-PREV-ITEM trigger in radio group.For my testing i have also written go_item in this trigger,but still it fails.
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.
View 2 Replies View Relatedi 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...]
View 5 Replies View RelatedAPEX 4.1 / 11g
Theme 21
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 2 BLOCKS E.G. MASTER-DETAIL AND i have created it manually then how to insert values thrugh these blocks using a button called "save" using "commit_form;" suppose form fields are
master-block:
emp_id
emp name
age
detail block:
address
city
where emp_id is primary key as well foreign key in detail table
how these values will be inserted in both tables
I have two tables one is
1)create table abc(c_name varchar2(10),c_number number(6),c_loc varchar2(8)); --having values
2)create table temp(sname varchar2(10),sid number(4),address varchar2(10));---no having
and my question is how to insert a values into temp using when-button-pressed trigger based on abc table in oracle form.
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 have 2 files rep.rdf and rep.fmb
i made parameters for userid and dept its working fine but
how can i make order by parameter using radio buttons
what i add in report and form ?
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);
else
set_item_property('remarks',enabled,property_true);
set_item_property('remarks',visible,property_true);
end if;
end;
error is:::
argument to built in get_item_property/field char can not be null?
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.
We are running Oracle Enterprise software on various client and DB servers and we are experiencing a problem (outlined here ) where the apparent mismatch between the oracle drivers are causing the errors. Our db servers are using 10.2.0.4 and 10.2.0.5 drivers and the clients are using 10.2.0.1.
Firstly, are the drivers the same on the Express and Enterprise editions so that if I update a development server usingExpress version (I dont have the authority to upgrade the Enterprise version nor the time to commission that) and it is successful, can I reasonably expect an upgrade to the Enterprise client versions on other servers to be safe/error free, baring environmental factors of course ?
Secondly, can I upgrade to version 10.2.0.5 now or do I have to go to the 11g version only ?
We are running Oracle Enterprise software on various client and DB servers and we are experiencing a problem (outlined here [URL] .....) where the apparent mismatch between the oracle drivers are causing the errors.
Our db servers are using 10.2.0.4 and 10.2.0.5 drivers and the clients are using 10.2.0.1.
Firstly, are the drivers the same on the Express and Enterprise editions so that if I update a development server using Express version (I don't have the authority to upgrade the Enterprise version nor the time to commission that) and it is successful, can I reasonably expect an upgrade to the Enterprise client versions on other servers to be safe/error free, baring environmental factors of course ?
Secondly, can I upgrade to version 10.2.0.5 now or do I have to go to the 11g version only ?
While i'm doing delete obsolete backup its Throwing error.
RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Datafile Copy /u01/app/oracle/oradata/demo.ctl
I have a editing database with an eversions table:
NAME OWNER
---------------------- --------------------------------
WR5936_DN6676 FRED
WR6739_DN7507 FRED
WR12744_DN13994 FRED
WR6739_DN7511 BARNEY
WR6801_DN7513 BARNEY
I have a process database with a pversions table:
SOID
----------------
5936
6739
12744
6739
I need to select from the editing.eversions table all the records that do not have a matching record in process.pversion. The eversion table is text, and has some additional crap surrounding the characters I want to use for creating a join.
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...??
View 2 Replies View RelatedI 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?
View 9 Replies View RelatedIs it possible to add some custom image on a button?
If so, How to do it?
I try to apply update statement on the button for the specific records, the command does executes if in the end i write execute_query it always asks for do u wanna save the records, yes or no. I want to remove that message. Also if i write commit it does remove that message but everytime i press the button it updates the old record fine but also adds one more entry for the same record.
View 5 Replies View RelatedI am working on form 6i. I want to disable the 'SAVE' button which can be seen in the menu (front end).
View 2 Replies View RelatedWithout using any templates, i created a customized sample form....now i want to add data thru that form....i dont know where to write code and what is code if i want to add data?
View 9 Replies View Relateddeclare
blk_name varchar2(60);
form_name varchar2(60);
[Code].....
this is my coding on save button. this is working fine but only once. when i enter the data second time and try to save, it didn't do anything. what should i do?