Solved

STACK AND TAB CANVAS HORIZONTAL VERTICAL TOOLBAR RELATED QUERIES ORACLE FORMS

Posted on 2013-12-21
1
1,735 Views
Last Modified: 2013-12-23
I have made one tab canvas , there are 4 tab pages (4th tab page is for exit)
On 1st tab page i have created emp block (source table emp) ,
On 2nd tab page i have created dept block (source table dept),
On 3rd tab page named as "About" when i navigate to About it displays stack window
which i have already created on which i have written details about Developer i.e me .
There is one push button on stack window i.e "OK " , when user clicks OK button stack
window get closed and cursor get back to 1st tab
Code for push button :-
Code: [Select all] [Show/ hide]

hide_view('stackcanvasname');
go_block('emp');



Now my question is
1. I want to navigate to tab page instead of navigating to block
Is there any command to go back to tab pages like go_block and go_item
2. When i use only hide_view('stackcanvasname'); command inside push button i.e 'OK'
and when i press OK button the window doed not get closed why? is there any solution for this


II). Toolbar related queries.
1. I have creates two canavas a.Normal Canvas b. Horizonatal toolbar
I have created one block using normal canvas , and on 2nd canvas i.e Horizontal toolbar ,
on that i have made few buttons to execute_query ,to navigate on records etc
The problem is when i run this form it shows me only horizontal toolbar canvas
and when i maximize window that it shows me 2nd canvas.
My requirement is I want to display both Canvas at same time when i run my form.

2. I am not able to make horizontal toolbar and vertical toolbar in same form , why ?

Kinly Help. Thanks
0
Comment
Question by:hinamansoor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 9

Accepted Solution

by:
MarkusId earned 500 total points
ID: 39735476
Hello,

Answers for the tab-page questions:

1. You can try to use the 'set_canvas_property'-builtin. However, I suppose the same applies here as with the 2nd point below regarding the active item - move to a neutral field (e.g. on a toolbar) first.
SET_CANVAS_PROPERTY('canvasname', TOPMOST_TAB_PAGE, 'tabpagename'); 

Open in new window


2. You have to move the cursor out of the canvas first, so the right sequence of commands should be'c
go_block('emp');
hide_view('stackcanvasname');

Open in new window

Oracle does not allow a canvas to be hidden as long as the cursor is in an item on that canvas.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question