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?

View 8 Replies


ADVERTISEMENT

Forms :: How To Disable Radio Button

Jul 16, 2013

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,...)

View 1 Replies View Related

Forms :: Parameters After Radio Button

Dec 16, 2012

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.

View 3 Replies View Related

Forms :: Code To Get Label Of Radio Button

Aug 30, 2006

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?

View 4 Replies View Related

Forms :: Radio Button Mismatched Values

Mar 22, 2012

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.

View 4 Replies View Related

Forms :: Hangs While Doing A Shift Tab On Radio Button?

Sep 12, 2012

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.

View 3 Replies View Related

Forms :: User Click On Radio Button To Save It On DB

May 2, 2010

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 .

View 1 Replies View Related

Forms :: How To Insert Value Of Selected Radio Button In Database Table

May 10, 2010

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.

View 1 Replies View Related

Forms :: Get Chosen Value In Radio Button Into Text Item Which Is In Another Form?

Feb 25, 2013

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?

View 7 Replies View Related

Forms :: How To Check Only One Radio In Radiobuttons Of Radio Group

Aug 2, 2013

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 Related

Application Express :: Default Value Of Radio Button Based On A Condition?

Oct 1, 2013

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...] 

View 5 Replies View Related

Application Express :: Hiding / Displaying Regions Using Radio Button Not Working?

Jun 30, 2012

APEX 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.

View 5 Replies View Related

Forms :: Trigger Program To Track User Information

Jun 25, 2013

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 /

Warning: Trigger created with compilation errors.

SQL> show errors;
Errors for TRIGGER TRI_TRACK:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/1 PL/SQL: SQL Statement ignored
3/95 PL/SQL: ORA-00917: missing comma

View 3 Replies View Related

Forms :: Keep Track Of Item Value Totals In Header From Items Under Each Activity

Nov 24, 2010

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.

View 1 Replies View Related

Forms :: Oracle Checkbox / Submit Button?

Aug 1, 2012

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.

View 11 Replies View Related

Forms :: Radio Box Disable

Dec 1, 2010

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.

View 4 Replies View Related

Forms :: Alert Cancel Button Gives Non Oracle Exception

Jan 20, 2011

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?

View 5 Replies View Related

Replication :: Oracle Forms 10g Access Key Property For Button

Jan 22, 2013

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?

View 6 Replies View Related

Forms :: How To Create Browse Button In Oracle Form Builder

Mar 19, 2010

I would like to create a browser button which enables to browse a tree directory and to select a file. how can i do it?

View 1 Replies View Related

Forms :: Order By Parameter Radio Buttons

Apr 29, 2012

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 ?

View 2 Replies View Related

Forms :: Dynamic Access To Radio Buttons?

Feb 18, 2010

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?

View 1 Replies View Related

Forms :: To Get X-pos Of Item At Radio-change Trigger

Jun 22, 2013

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?

View 1 Replies View Related

Forms :: Radio Buttons Don't Work In ENTER-QUERY

Mar 11, 2010

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.

View 2 Replies View Related

Forms :: Run Report Developed By Crystal Reports By Click On Button In Oracle Developer 6i?

Dec 19, 2011

I want to run a report developed by crystal reports by click on a button in oracle developer 6i.

Is it possible. If yes then how can i do this.

View 8 Replies View Related

Server Administration :: How To Track The Last Access To A Table

Oct 11, 2011

is it possible to track the last access to a table?

View 2 Replies View Related

SQL & PL/SQL :: Track Department Change - Update A Counter

Jun 22, 2011

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]..........

View 5 Replies View Related

Forms :: How To Add Image As A Button

May 14, 2011

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 Related

Forms :: Button On LOV - Oracle10g

May 17, 2011

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?

View 9 Replies View Related

SQL & PL/SQL :: Keep Logging Track Of Each Task Performed In Procedure Packages

Nov 26, 2010

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.

View 4 Replies View Related

SQL & PL/SQL :: Adding Audit Column To Track Delete And Update

May 15, 2012

we received a design advise to add columns to track the update and delete done on each row in our tables:

- DELETED_DATE_TIME
- DELETED_BY
- UPDATE_DATE_TIME
- UPDATED_BY

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.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved