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