?
Solved

STACK AND TAB CANVAS HORIZONTAL VERTICAL TOOLBAR RELATED QUERIES ORACLE FORMS

Posted on 2013-12-21
1
Medium Priority
?
1,762 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 2000 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

752 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