Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

STACK AND TAB CANVAS HORIZONTAL VERTICAL TOOLBAR RELATED QUERIES ORACLE FORMS

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

618 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