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:




When the Form loads, I am unable to align text boxes from CG$SPREAD_TABLE_1 canvas with CG$PAGE_1 canvas.

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);