way to set the properties of a visual attribute group during runtime? During our forms 6 to 10 conversion we missed that our visual attributes for mandatory and not-manadatory items were different, so we have font size 8 and 9 in our system now, does not look very nice.
View 1 Replieshow to get visual attribute name into a variable ??I have used the below code....
s_v:=get_item_property('slot1',visual_attribute);
but i am unable to get the name of the visual_attribute..
I have a database block that refreshes using a timer. In short, I list all open work pieces for a certain garage, displaying route, run, on_time, of_time, location grouped by garage, on_time, off_time
I need to highlight every garage with a different color. I am highlighting the on_time every time the garage changes.
The problem is, every time I move down the records, instead of keeping the previous garage color, and highlight the new garage on_time with a new color, the whole on_time column will be set to the current garage color.
I need to break down the block by color so the user can distinguish between the different garages, and the start and end time. Here is my code, I am putting it in when_new_record_instance of the work_block:
IF :work_bLock.current_garage = 9006 THEN
Set_Item_Property('work_block.on_time', BACKGROUND_COLOR, 'r191g223b191');
ELSIF :work_bLock.current_garage = 9002 THEN
Set_Item_Property('work_block.on_time', BACKGROUND_COLOR, 'r255g228b196');
ELSE
Set_Item_Property('work_block.on_time', BACKGROUND_COLOR, 'r255g250b250');
END IF;
I need the block to be 3 or more different colors depending on the garage.
I m using oracle forms 9i in which i want effect on text fields that will change color of text after mouse cursor move on that field . is it possible in oracle form 9i .
View 6 Replies View RelatedI want to change the current visual attribute color of my form at the application level, reason being i don't want to generate all the forms again from scratch.I know that we can change this using visual attributes but is there a way to change this through some form setting?(Oracle 10g)
View 3 Replies View RelatedI ran into something that has me wondering about which errors are caught at compile-time, and which are caught at runtime. There is a pretty big package with lots of complicated queries that heavily use GROUP BY, and in the last couple of years I thought I never had the case of an ORA-00979 happening an RUNTIME, which is now happening.
The last heavy changes in that package did I make in the Oracle 9.2 days, and I *believe* (although my memory might be wrong) that back then the ORA-00979 errors came up at compile time.
So is it normal that the error doesn't show up during compile time, only during runtime, or should it be considered a bug?
SQL> CREATE TABLE test_tab(a NUMBER(1), b NUMBER(1));
Table created.
SQL> INSERT INTO test_tab VALUES (1,1);
1 row created.
SQL>
SQL> CREATE OR REPLACE PROCEDURE test_prod AS
2 v_a NUMBER;
3 v_b NUMBER;
4 BEGIN
5
6 SELECT a,b
7 INTO v_a, v_b
8 FROM test_tab
9 GROUP BY a;
10
11 END;
12 /
Procedure created.
SQL>
SQL> BEGIN
2 test_prod;
3 END;
4 /
BEGIN
*
ERROR at line 1:
ORA-00979: not a GROUP BY expression
ORA-06512: at "PFK.TEST_PROD", line 6
ORA-06512: at line 2
I have created a simple master/detail form which is in easy navigation for user. The form have master/detail block with tabular style showing 5 records, When user click on master record the detail will show the opposite as master record point.
See attached file.
How to check table properties? (desc only shows if it is null)If I do desc emp, it only shows the Employee description. But Doesnt tell if table is having primary key or not?
View 2 Replies View RelatedThis facility has one last 10g database and a very problematic tablespace and last datafile associated with it. The tablespace was set up with INITIAL_ EXTENT of 131,072 (128K) instead of the more 'normal' 4,194,304 (4M) and NEXT_EXTENT of 262,144 (256K) instead of 4,194,304 (4M).
More worryingly, the datafile has INCREMENT_BY set to 1 (8K) instead of 1,280 (10M) or 2,048 (16M).Has anyone ever updated sys.ts$.dflinit and sys.ts$. dflincr to modify the INITIAL_EXTENT and NEXT_EXTENT, and sys.file$.inc to modify the INCREMENT_BY?
I want to set font properties of Arabic text.
View 1 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?
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 Relatedhow can change image through runtime i mean if have 5 pictures first image will showing and second image showing
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 RelatedHow can I change the default runtime logo in forms 6i.
View 1 Replies View RelatedI develop a form using Devloper9i AS, oracle 9i, Winxp. The problem is: I used icon button at design view ".fmb" but at run time this icon disappears in the file ".fmx" After reading some topics covered this problem in this forum; The following steps are executed:
1-In regedit I put UI_ICON = c:icon --where my gif icon file is located
2-At command prompts i type: C:>jar -cvf icons.jar c:icons Then "ICONS.JAR" file is created on D:Dev9ijdkin
3- I Copy the file "ICONS.JAR" and past into D:Dev9iforms90java
4- I modify the "FORMSWEB.CFG" as follow:
archive_jini=icons.jar,f90all_jinit.jar;
imageBase=codeBase
4- In "Registry.dat" I added the flowing line:
default.icons.iconpath= c:icons
5- I modify the "orion-web.xml" .as follow:
<virtual-directory virtual-path="/html"
real-path="D:Dev9i/tools/web90/html" />
is modified to :
<virtual-directory virtual-path="/ICONS"
real-path="C:ICONS" />
6- In the property palette for the icon item and in the Icon Filename I put just the icon name called "w_prev" Without any extension , any path...
How To Display Runtime Calculation in cursor for example in loop i define xyx number then add + 1 in xyz and move its value to block item until loop valid but in display no value shown but if i apply message(xyz) then it also shown the answer is correct but with message style i click every time in message but i want that with some delay form automatically show the value of xyz in block field.
View 3 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 want to change the button color in the runtime. is it possible by using set_item_property. if not, can we set by using property palette at design time.
i tried by setting the property in both ways but it's not working.