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


ADVERTISEMENT

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 :: 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 :: 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

SQL & PL/SQL :: Order By Based On Input Parameter?

Jun 29, 2011

I have created the Procedure P_GET_CURRENCIES. I want to sort the cursor query based on the Input parameter P_SORT_ORDER. For example if i pass 2 for P_SORT_ORDER then my query should be sorted by 2nd column. But i'm not getting correct Output.

PROCEDURE P_GET_CURRENCIES(P_START_ROW_NUM IN INTEGER
,P_END_ROW_NUM IN INTEGER
,P_SORT_ORDER IN number
,P_CURRENCY_DATA OUT SYS_REFCURSOR
,P_RETURN_MESSAGE OUT VARCHAR2 )
AS

[code]....

View 3 Replies View Related

Forms :: Icons In Buttons

Feb 23, 2011

I have Forms 11g in Unix environment.

I can't see icons in buttons. I have a custom smartbar and some custom icons on it, and it get displayed, but when it comes to buttons, nothing. Not even the default buttons that comes inside frmall.jar are displayed. What i don't understand is how do they get displayed on the smartbar and not on buttons?

As you can see, i already have the necessary changes to display icons, such as all small case, changes in formsweb.cfg, registry.dat... I get the icons to be displayed in browser. If i put them on a jar file, the jar file is downloaded as i can see in java cache, but never shows. I already tried several different GIF's, different image sizes, different button sizes, colors, names, etc.

View 2 Replies View Related

Forms :: Icons Not Showing On Buttons?

Sep 26, 2012

We are using ERP based on Oracle 10g forms, there is icons on the buttons those icons are displaying when we uses the ERP in Windows based client and browser Internet Explorer.But when we uses Opera browser we are getting ERP but icons are not displaying.

Same way when we uses Linux client machine using Mozilla Firefox there also the icons are not displaying.

View 3 Replies View Related

Forms :: Vertical Text On Buttons

Jan 5, 2011

Refresh my memory if there's a way to display vertical text on buttons in forms?

e.g. v
e
r
t
i
c
a
l

View 3 Replies View Related

Forms :: Cannot Display NEW GIF Files As Icon On Buttons

Feb 23, 2011

I already have and use .gif files for icons on various buttons in my forms. I need to use a different .gif file to create a new icon. When I enter the file name of the new .gif is not displayed on the button. If I reference an old and working .gif. The .gif appears on the button. What rules if any, must I observe when creating/using .gif files as icons for buttons?

Does the .gif file have to be of a special type? If so, what will I need to do?

View 1 Replies View Related

Forms :: How To Use Multiple Buttons To Sort Columns

May 6, 2010

I am maintenancing a form which I have to add buttons as headers that will sort each column's data either in desc or asc order when the user click each button. How is this done? I need to know what built-in function that will closely do this or cod.

View 19 Replies View Related

Forms :: Put Icons On Buttons In Oracle Developer 10?

Jun 4, 2012

i want to put icons on buttons in oracle form developer 10g. and make some different style.

View 2 Replies View Related

Forms :: Create Iconic Buttons In 9iDS?

Feb 26, 2010

Regarding The Creation of ICONIC Buttons in FORMS 9iDS, I Have Tried All The Methods But In vain.

View 1 Replies View Related

Forms :: How To Add Animated Buttons And Analog Clock In Form

Oct 24, 2013

I found one video on youtube , in that that person has made animated buttons and added analog clocks inside that form but he didn't tell how did he do that , so i am attaching gif file because video file is not allowed , this file will give you whole idea what is actually i am saying.

I just want to to know how to do this , I want coding part for animated buttons and for analog clock only, rest i can do on my own . And this video made me think one thing can we add marque in text in oracle also, as we do in HTML to move text. If it is possible then how can we do that.

View 7 Replies View Related

Forms :: SUBMIT Buttons Which Is Disabled / Gets Enabled Automatically

Apr 3, 2012

I have a scroll bar in my form. When i scroll the bar, one of SUBMIT buttons which is disabled gets enabled automatically. Do we have any triggers on scroll bar where i can disable the button again.

View 4 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 :: When Pressed F-11 And Ctrl F11 Buttons Screen Doesn't Turn Blue

Oct 19, 2009

I developed custom form, everythng is working fine. but when i press F-11 & Ctrl F-11 it queries and gtes the record.

But when I press F-11 ,fields on the screen doesnt turn blue.

View 10 Replies View Related

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 :: 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 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 :: 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 :: 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

Performance Tuning :: Order Of Steps In Execution Path And Order Of Predicates In The Plan

Mar 20, 2012

Which step in the following plan is the first step of execution

I reckon it is "TABLE ACCESS BY INDEX ROWID| BANK_BATCH_STATE"

Is that correct?

In the "Predicate Information (identified by operation id):"

section the predicates - access and filter for the step "TABLE ACCESS FULL | PYMNT_DUES" are displayed first

Isn't there any relation between the order of execution steps and the order in which predicates are displayed?

Execution Plan
----------------------------------------------------------
Plan hash value: 538700484
-------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 2364 | 15 (14)| 00:00:01 |
|* 1 | FILTER | | | | | |
| 2 | HASH GROUP BY | | 1 | 2364 | 15 (14)| 00:00:01 |
| 3 | NESTED LOOPS | | 1 | 2364 | 14 (8)| 00:00:01 |
| 4 | NESTED LOOPS | | 1 | 2313 | 13 (8)| 00:00:01 |
| 5 | NESTED LOOPS | | 1 | 2281 | 12 (9)| 00:00:01 |
| 6 | NESTED LOOPS OUTER | | 1 | 2255 | 11 (10)| 00:00:01 |
|* 7 | HASH JOIN | | 1 | 175 | 6 (17)| 00:00:01 |
|* 8 | INDEX RANGE SCAN | INDX_2 | 12 | 612 | 2 (0)| 00:00:01 |
|* 9 | TABLE ACCESS FULL | PYMNT_DUES | 43 | 5332 | 3 (0)| 00:00:01 |
| 10 | VIEW PUSHED PREDICATE | | 1 | 2080 | 5 (0)| 00:00:01 |
| 11 | NESTED LOOPS | | 1 | 154 | 5 (0)| 00:00:01 |
| 12 | NESTED LOOPS | | 1 | 103 | 4 (0)| 00:00:01 |
|* 13 | TABLE ACCESS BY INDEX ROWID| BANK_BATCH_STATE | 1 | 32 | 2 (0)| 00:00:01 |
|* 14 | INDEX RANGE SCAN | INDX_BBS_1 | 3 | | 1 (0)| 00:00:01 |
|* 15 | TABLE ACCESS BY INDEX ROWID| DAILY_CHECK | 1 | 71 | 2 (0)| 00:00:01 |
|* 16 | INDEX RANGE SCAN | INDX_SEARCH | 1 | | 1 (0)| 00:00:01 |
|* 17 | INDEX RANGE SCAN | INDX_2 | 1 | 51 | 1 (0)| 00:00:01 |
|* 18 | INDEX RANGE SCAN | INDX_IAM_SR_NO | 1 | 26 | 1 (0)| 00:00:01 |
|* 19 | INDEX RANGE SCAN | INDX_2 | 1 | 32 | 1 (0)| 00:00:01 |
|* 20 | INDEX RANGE SCAN | INDX_2 | 1 | 51 | 1 (0)| 00:00:01 |
-----------------------------------------------------------------

View 3 Replies View Related

SQL & PL/SQL :: Result Order In 2 Table Joins Without Order By

Sep 6, 2011

I have below tables,

describe rpthead

Name Null Type
--------------------------- -------- -------------
RPTNO NOT NULL NUMBER
RPTDATE NOT NULL DATE
RPTD_BY NOT NULL VARCHAR2(25)
PRODUCT_ID NOT NULL NUMBER

describe rptbody

Name Null Type
------------- -------- -------------
RPTNO NOT NULL NUMBER
LINENO NOT NULL NUMBER
COMMENTS VARCHAR2(240)
UPD_DATE DATE

The fact is that we store some header in RPTHEAD and store real data in RPTBODY, the question is that if I use below SQL to query all data for a 'PRODUCT_ID'.

SELECT t0.LINENO, t0.COMMENTS, t0.RPTNO, t0.UPD_DATE
FROM RPTBODY t0 , RPTHEAD rpthead
WHERE
(
t0.RPTNO = rpthead.RPTNO
AND
t0.UPD_DATE>=to_date('1970/01/01 00:00:00','YYYY/MM/DD hh24:mi:ss')
AND
rpthead.PRODUCT_ID IN ('4647')
)

I do not want to have 'ORDER by' clause since data set is too large, the sorting takes long time, is there any way to get the result rows in the order sorted by RPTNO? We have the index for RPTNO on RPTBODY.

View 5 Replies View Related

Forms :: Can Change The Order Of Triggers In 6i

Dec 12, 2012

can change the order of triggers in forms 6i . that means firing in form level?

View 4 Replies View Related

Forms :: Order By Current Month

Jan 30, 2011

A form has date of birth column.

Date of birth should be displayed according to current month.

Example:
01-jan-1980
01-feb-1975
01-mar-1970

Required:

Let current month is feb then
01-feb-1975
01-mar-1970
01-jan-1980

What should be done?

View 5 Replies View Related







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