Forms :: Change Values (increase / Decrease) In Runtime?
Jan 6, 2012I having one list field which contains 31 values.
how can i change the values(increase/decrease) in the runtime.
I having one list field which contains 31 values.
how can i change the values(increase/decrease) in the runtime.
how can change image through runtime i mean if have 5 pictures first image will showing and second image showing
View 1 Replies View RelatedHow can I change the default runtime logo in forms 6i.
View 1 Replies View RelatedIs it possible to change the item_type property of an item at runtime.
I have one text item and i need to lock(Read only) that item. I hope we can change the ENABLED property or by changing the ITEM_TYPE as DISPLAY_ITEM.
How to change the Item_Type to DISPLAY_ITEM from TEXT_ITEM at run time or else is there any other way except ENABLED property to male the field as READONLY.
I have a text item in the control block and I want to change the background color at runtime..I used set_item_property but it doesn't working.I used WHEN-MOUSE-MOVE TRIGGER at the field level and the code.
is
SET_ITEM_PROPERTY(':master_blk.department', FOREGROUND_COLOR, 'VISUAL');
'VISUAL' is the visual attribute name and before making the visual attribute I used
SET_ITEM_PROPERTY(':CONTROL.CREATE', FOREGROUND_COLOR, 'red');
but it was also not working..
I have text item and it is assigned with lov namely 'Typelov' and that xlov assigned with 'Rgtype'. When I create the record group i just create with sql
like
select distinct type from x;
But at runtime i want to change the query
select distinct type from x where col1 = 'XXX';
and now the lov should display the above filtter condition item only.Is there any possible
can we change a field font size on runtime(by something like "SET_ITEM_PROPERTY built-in").(Independent of "Registry" file.)
View 5 Replies View RelatedI want to change Database Data Block Property at runtime.
View 4 Replies View Related I'm having a problem with null values. I want to display old student in a display item if subjects text item has records. Otherwise, display new student if it has null values. This is the code that i tried so far..
IF :block2.subjects IS NULL THEN
:block3.type := 'NEW STUDENT';
ELSE
:block3.type := 'OLD STUDENT';
END IF;
But i got logic error during runtime.
how i can change the value of text in the runtime?
View 6 Replies View RelatedI want to change database login in report at runtime.
For Example. I have created and run a menu by using database login "ABC/xxx" and want to run a report through this menu directly (Without using form) by different data base login i.e "xyz/ddd".
what is the sol. except passing user id at report call i.e rwrun60 parameter.
I´m newbie as Apex developer using Apex 4.0 with OracleXE 11.2, and now my problem is:
I have a tabular form where one of the columns, when calling the form, is a Display Item, so that you cannot change existing values.
I want, when adding a new row, that column become a Select List (named LOV) based on a query that exclude existing values in other rows already inserted.
Can I change that Display Item to Select List (named LOV) programmatically at runtime? If not, what other options do I have?
I want to decrease the size of testid column of number datatype in my "test" named table from size 20 to 15 and the data of maximum size is of 10 digits. but oracle throws an error "ORA-01440: column to be modified must be empty to decrease precision or scale". i cant understand why it is happening?
what is the reason behind it even though new size is maximum than the maximum size of existing data. but when i decrease the size of "varchar2" then oracle does not through any error.
11gxe , apex 4.0 , firefox 24 ,i want to decrease width of a specific region , how ?
View 3 Replies View Relatedhow to decrease the size for list manager
View 0 Replies View Relatedwe are currently migrating from forms 6i to 11g. We would like to cleanup our global variables at runtime.
Is there any way to list the global variables at runtime?
I'm planning to decrease the time taken to execute data by managing the redo log file but I'm kinda stuck in some aspect : > Why is my OPTIMAL_LOGFILE_SIZE is showing NULL ? > I'm trying to resize the LOGFILE capacity from 100M to 200M and I'm also adding 1 more LOG GROUP with 200M capacity too but turned out that didn't decrease my execution time.
View 12 Replies View RelatedI have a problem with Tabular form. Configuration: Oracle 10g, Application Express 4.1.0.00.32.
I have tabular form on simple table. I need to change some column values before MRU. For example: i have column named "UPDATE_DATE" where i need write SYSDATE every time this record was updated. I've created page process, associated with my tabular form.
Process point: On Submit - After Computations and Validations;
Sequence set to 1 (before "ApplyMRU" process - it has sequence 10);
When Button Pressed: Submit;
Execution Scope: For Created and Modified Rows;
Source:
declare
indx varchar2(255);
l_map wwv_flow_global.vc_map;
l_id number;
l_pk number;
begin
[code]........
But this doesn't work. MRU process writes old values, that was posted from browser. I tried change values by
apex_application.g_f04(:APEX$ROW_NUM) := sysdate;but this also not work.
How can i change values before MRU? Why wwv_flow_tabular_form.set_row_values doesn't change values?
is there a way to keep the display of the form when we call another new form. my scenario will be as following:
am in form1 , i call form 2 from a menu, after this call form2 is open in place of form1.
i have no control in form1 and i can't change anything on it, i don't know hw the menu option is calling form2.the only control i have will be within form2 if there is any change i can make it.i read something about MDI, and OPEN_FORM() procedure, but i think this will required a change in form1 which i can't do.
is there any change i can make in form2 to display it and keep the display of form1 at the same time behind it ?
How can I get forms and reports runtime and from where?
View 2 Replies View Related find the attached file.i want to get the remarks on runtime.i have written this formula in when_validate_item.
declare
a number;
begin
a := nvl(:get_mark,0);
if a >= (33/100)*:get_mark then
:remarks := 'PASS'
[code]...
I want add a text item at run time depending on the number of values retrieved i want to change the number of text items. Is it possible at run time to add a text item?
View 1 Replies View RelatedWe have a Form for viewing some datas, now i need to create a new button and Hide that button while run time for All Users except one user, how to set this option.
Addl.info: This Button should be displayed only for a single user login not for all the users using that form. how to make this option?
Is it possible to read the application URL while running the application
[URL]
Above is my URL i need to read i and t hold it on a variable at runtime
i want to set the icon on my forms i write these lines.... for to do this...
MDI_ICO := WIN_API_UTILITY.GET_ACTIVE_WINDOW;
WIN_API_SESSION.CHANGE_MDI_ICON(MDI_ICO, '.IconsCOMPANY.ico', 0);
and i also attached the library d2kwutil.pll and when i run the form then this error raised...
FRM-40734: Internal Error : PL/SQL error occurred..
now what can i do for set the icon at run time..the first part of the message has been removed as it belongs to @allianz2010's previous topic; the rest has been split into a new.
I have one form that is migrated from oracle forms 6i to 11g. I opened that form by 11g form builder and it has 3 text items. Then i run the form from 11g builder...here is my problem, only 2 text items are displayed in my browser(IE). another one is invisible... i checked the property pallet for that particular text item.
i checked the following properties and its value in my form:
enabled=yes
visible=yes
but the text item is not visible.
Can We Create Forms Runtime in Oracle Forms 10g Like Oracle Forms 6i
View 1 Replies View Relatedi need to position my canvas at run time.
View 3 Replies View RelatedMy form has to go into two different environment in which the one column name of a table is different. datatype is same.
I would like to change the database column name of the item in the form for that block at run time.
How To Run Forms 6i from Server without Runtime Installation on Client Pc.
View 5 Replies View Related