I need to modify an existing form, thus I have to resize a canvas and a window for it. In windows, I run it and I got the right display. When I transfer it to dev server running in linux, then I compile and run it, it display the previous/unmodified size. I'm sure my form is the one that running, I placed some text there and it was displayed.
View 4 RepliesIs it possible to have a standard size for canvas or window of the form? like different users are having different screen resolutions and may have different screen sizes which cause forms not to come proper on the user screen. Is there some solution to avoid the user's resolution and should work on some standard measurements?
View 5 Replies View RelatedI want to call another canvas in same window.using this code /it not work show_view('canvasname');
View 1 Replies View RelatedI use forms10g in windows xp, i create a tap and toolbar canvases in content canvas but at runtime i can see only toolbar canvas.
View 1 Replies View RelatedI have to modify the Form layout of an existing application (Application Express 4.0.2.) where the data for each field is retrieved using SQL statements
Presently the form looks something like this and the Data for each field is rendered properly in this layout:
UNIT # : 123456
ADMISSION #: 2012101510 DISCHARGE DATE: ADMISSION DATE:
FIRST NAME: JON LAST NAME: DOEFIRST NAME, LAST NAME and UNIT # are all "Display Only" item type.
What I'm trying to do is to move "FIRST NAME" underneath "LAST NAME" and "UNIT #" next to "LAST NAME" This part is very simple. However, the issue I'm having is as soon as the "UNIT #" is moved next to "FIRST NAME", the data for "FIRST NAME" and "LAST NAME" simply disappear
This is how it looks
ADMISSION #: 2012101510 DISCHARGE DATE: ADMISSION DATE:
FIRST NAME: UNIT #: 123456
LAST NAME:
I have played around for hours and even created from scratch a new page with a new form using SQL statements to pull the data for each field, only to get the same result.
is there a way to set the default sizes for the canvas, object navigator and properties window in forms designer so that they don't maximise when opening them. i tried to set them in the caupref and cagpref files to no avail.
View 4 Replies View RelatedI need to know how to modify the spfile - I know how to create it from scratch (from pfile to spfile), but need to modify an existing spfile.
View 3 Replies View RelatedI'm facing a really strange problem in Forms with an FMB that has a couple of canvas, but the main one canvas is showing a JPG (like a Wall Paper for the application, in fact this FMB would be the main FMB and it will call the main menu also). The problem is on run-time (locally, running on windows, just in some Laptops). At execution time, there's a FRM-92102 error, but only deleting the image, and trying again, the Screen run perfect!
The worst part is that same FMB run perfect on other laptops. I've tried almost everything : Creating again, just the form with one canvas and importing the image, and Run, but same error appears again. Trying with another image, same results.
I want to achieve functionality like below:
Let's say there are two almost identical window and some specific functions associated: W1 and W2.
Depending upon the login profile into the application only one window and associated functions will be appeared. This time the other window will be disabled.
i have a form based on tab canvas. for some values(on form) i am hiding some fileds or a complete frame on the form using stack canvas. it works fine but if a user enters a wrong value in some field i.e enters character in number field the stack canvas hides(showing the hidden fields).
I tried to use on error trigger at form level and when validate item trigger to show the canvas but it first hides the canvas once right value is entered it just shows canvas again. following is the code i wrote
IF MESSAGE_TYPE = 'FRM' AND MESSAGE_CODE IN ('40209','50016')
AND :SYSTEM.TRIGGER_ITEM IN (some field)
THEN
IF other_item_value = 'E' THEN
SHOW_VIEW('STK_CAN_ARL_INFO');
END IF;
I need not to hide the canvas in any case whether any other field on the form is validated or not.
We are in the need of calling Mapping Software from with in Forms, most likely Google Maps, and keep the form locked until selections are made. The attempt was to call the URL from a Modal Window that would in turn lock the form until return.
The attempts were using WEB.SHOW_DOCUMENT, this process releases the form as soon as the call occurs. Then the desire to use UTL_HTTP, but with this process it would cause the DBA to setup a Wallet_Path for Certification of the call. This one has not been explored as yet.
There is a existing form B. From a form A I need to call form B on button press. Problem is form B has many tabs,It should open in the third tab when it is being opened from form A.
View 1 Replies View Relatedis there any method in placing a stacked canvas inside a tabbed canvas ?
View 8 Replies View RelatedI have Table that save a color (specific color) , i want to change this color for all forms included windows and canvases at Runtime (by Code) .
My problem is : i can't move from canvas to canvas to change its color ( name of canvas ) - no next canvas code - like next block?
Can we place tab canvas in content canvas?i have created one header section based on content canvas.next line level i need to display tab.how can i do this?
View 1 Replies View RelatedI have tried enough to put Tab canvas on content canvas so that they can appear in the same window. I have tried on internet and unluckily find only
[URL].....
I didn't understand how to do it.
We have placed Stack canvas on tab canvas. The Stack canvas will be visible/Invisible based on some condition dynamically. The Issue is When you show the stack canvas by using Hide_View('Canvas') , the stack canvas is shown on all tab canvas instead of displaying in the first tab canvas.
How to over come this issue and can we place stack canvas on tab canvas?
I've a 2 stacked canvases(canvas_live_appmnt, canvas_cancelled_appmnt) and Tab canvas(cc_main).Now I need to move the stacked canvas on the Tab canvas.I tried writing the When-tab-changed trigger as follows: In the below code I was trying for only one of the stacked canvases.
DECLARE
L_LOCAL_TP_NAME VARCHAR2(30);
BEGIN
L_LOCAL_tp_name := GET_CANVAS_PROPERTY('CC_MAIN',topmost_tab_page);
IF L_LOCAL_tp_name = 'LIVE_APPOINTMENTS' then
SET_VIEW_PROPERTY('CANVAS_LIVE_APPMNT',VISIBLE, PROPERTY_TRUE);
--SET_VIEW_PROPERTY (FIND_VIEW ('CANVAS_LIVE_APPMNT'), DISPLAY_POSITION, 0 , 325);
ELSE
SET_VIEW_PROPERTY('CANVAS_LIVE_APPMNT',VISIBLE, PROPERTY_FALSE);
END IF;
END;
I want to create a tabular type form on a tab canvas.. but my fields are often out of the form range. i want to create a stack canvas on tab canvas but it say that stack canvas and tab canvas must be created within content canvas.
how can i manage it what can i do now. i also attached pic of my tab canvas. i show some fields on tab canvas and 3 more fields i inserted on this canvas. And i can't reduced the width of my fields.
I cann't commit form when new instance form with form status is "NEW".
And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"
And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.
I have made an application in forms 6i. Now i want if user can update, or modify the data it will required automatic authentication. Administrator will gives his password then the updation will continue otherwise rollback the transaction.
View 1 Replies View RelatedI have a form with 2 content canvas. each canvas has its own windows.
canvas A is for inquiry person name
canvas B is people detail returned from first canvas.
now my problem is only A is showing when form instance
question: after open form, how to make both of canvas showing out. A active and B show behind
I have an form with a few canvases already in it. The problem is that I want to see a particular canvas which shows the toolbar at the top of the window but it dosent show up on the form. I checked the property palette and the canvas is visible. There is also an other canvas right at the top of the form. How do I move the other canvas down if this is covering the toolbar canvas. How do i move the canvas down as it dosent show any X position in its property palette.
View 1 Replies View RelatedHow to call the canvas from the menu module on which the form linked to the menu items.
The canvas lies in the same form where menu is attached.
I have a tab canvas with 4 tab pages.I want to set scroll bars for each tab page. I draw 4 stack canvas on 4 tab page but it doesn't transferred fields in each tab pages.
View 4 Replies View RelatedI'd like to hide my stacked canvas. This is my scenario, i have my content and stacked canvas on the same window. When i click a button on the content canvas it will display the stacked canvas, this is the code that i used:
SHOW_VIEW('CV_STACKED');
And on my stacked canvas, i put a button close and fired a when-button-pressed trigger,
HIDE_VIEW('CV_STACKED')
supposedly, it should hide the stacked canvas, but it doesn't hide. i tried SET_VIEW_PROPERTY('CV_STACKED', VISIBLE, PROPERTY_FALSE)
How to call the canvas from FORM A to FORM B . Form A contains canvas 'can_test'
Form B contains canvas 'can_sub'
I want to call 'can_test' from 'can_sub'
How to achieve this one?
is that datablock should have related to show the stacked which is hidden in content canvas
i have attached the stack.fmb
I have a problem while changing in a form canvas color
i make some modification in a form. The layout color of the canvas is blue. i want to change the layout color of it to default (<unspecified>) (which is the default color).
when i change in the property pallet the background color to <unspecified>. it give me that error FRM-12305 color by this name doesn't exist and i want it the default color.
how can i do it without recreating the form from the beginning.
I am using Forms 6i in Oracle Applications, In the button click event i used set_canvas_proeprty() twice. First time it executes these two statements, second time it does not. If i use any message() statement before these two statements, it executes.
Do we have wait() statement in Forms ?in apps we have app_item_property.set_property(), can we use same command to set canvas property also.