Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Unable to align items from one Canvas with another Canvas when the Form loads

buggleboy007Feb 26 2021

I am stuck in a problem and that is:
a) I have 1 window with many canvases. On one of the canvas(CG$PAGE_1; content canvas) I have one text box. On another canvas (CG$SPREAD_TABLE_1; stacked canvas) I have many text boxes.
CG$PAGE_1:
image.pngimage.pngimage.png
image.png
When the Form loads, I am unable to align text boxes from CG$SPREAD_TABLE_1 canvas with CG$PAGE_1 canvas.
image.png
The procedure that aligns the canvas is:
PROCEDURE CGLY$RAISE_CANVAS(
P_CANVAS IN VARCHAR2) IS /* Current canvas */
/* Raise the current canvas, plus any dependant canvases to the top */
BEGIN
SET_VIEW_PROPERTY(P_CANVAS, VISIBLE, PROPERTY_ON);
IF ( P_CANVAS = 'CG$PAGE_1') THEN
SET_VIEW_PROPERTY('CG$SPREAD_TABLE_1', VISIBLE, PROPERTY_ON);
END IF;
END;
I have tried the below options but nothing seems to be working. What can be done to rectify this issue?
-- Set_View_Property('CG$SPREAD_TABLE_1', VIEWPORT_Y_POS_ON_CANVAS, 150);
-- Set_view_property('CG$SPREAD_TABLE_1',width,12.4); --sets the viewport_width of the canvas
--Set_view_property('CG$SPREAD_TABLE_1',height,1.94); --sets the viewport_height of the canvas
--Set_View_Property('CG$SPREAD_TABLE_1', VIEWPORT_Y_POS_ON_CANVAS, 140);

Comments

Jim Smith
Did you install 3.0.04 in a fresh directory?
user9082530
Yes i did and also brought over the setting from the previous version. Thanks.
user5431290
I just went through the same thing...and I too needed to use subversion...

I downloaded the jdk from oracle and used the 'no-jdk' 3.1 version of sql developer ( i also had a 2.x version of sql developer that worked fine with subversion )...at first no joy

got the oracle.jdevimpl.vcs.svn.SVNProfile.canActivate(SVNProfile.java:162) error...every time

When I compared the preferences.xml file from

C:\Documents and Settings\<me>\Application Data\SQL Developer, I could see several directories reflecting the sql developer installations I had

to my 2.x installation ...

C:\Documents and Settings\<me>\Application Data\SQL Developer\system2.1.1.64.45

I found the folder o.jdeveloper.subversion.11.1.1.2.36.55.30

In there...I found preferences.xml...

In my
C:\Documents and Settings\<me>\Application Data\SQL Developer\system3.1.07.42 installation which at first did not work...

I found the
o.jdeveloper.subversion.11.1.1.4.37.59.48 folder...which also contained a preferences.xml file...however it was radically shorter and different than the 2.x version...


Copying the 2.x version to the 3.1 installation folder ( o.jdeveloper.subversion.11.1.1.4.37.59.48 )...and restarting sql developer did the trick...my subversion plug in now appears...


I have an SR opened with oracle to find out why the file got mangled in the first place...

Thanks
1 - 3

Post Details

Added on Feb 26 2021
1 comment
481 views