OraFAQ Forum: Forms » HOW TO CREATE A VERTICAL MENU

Home » Developer & Programmer » Forms » HOW TO CREATE A VERTICAL MENU (FORM 9I)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HOW TO CREATE A VERTICAL MENU [message #348383]

Tue, 16 September 2008 10:31

KULKARNI ONKAR
Messages: 12
Registered: September 2008
Location: INDIA

Junior Member

Hi,anyone know how to create a vertical menu. By
default when a form is deployed the menu comes at top center. I want it to be on left side of form and it should be in vertical manner.please reply it if you know

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #348769 is a reply to message #348383]

Wed, 17 September 2008 23:00

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Open the menu in the Forms Builder, then open the Menu Editor (double click the icons at the 'Menus' level), on the right hand side of the toolbat there is a button labelled 'Switch Orientation'. Try it.

David

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #349269 is a reply to message #348769]

Fri, 19 September 2008 10:14

KULKARNI ONKAR
Messages: 12
Registered: September 2008
Location: INDIA

Junior Member

Dear sir, I tried that earlier but it does not work at all. When I deploy that form ,the menus still come on top of the form. I want that at left side of that form and with collapse and expand capability. Also I want to call a fmx from that menu.
Please reply soon

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #349448 is a reply to message #349269]

Sun, 21 September 2008 21:11

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Then you need to use a 'hierarchy tree'. Search this forum or the help system.

To call an 'fmx', use one of either 'call_form', 'open_form', or 'new_form'.

David

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #349504 is a reply to message #349448]

Mon, 22 September 2008 01:57

KULKARNI ONKAR
Messages: 12
Registered: September 2008
Location: INDIA

Junior Member

All right sir, I will try it. But in case if I want this functionality in other form then again I have to create a vertical canvas and this tree items. Is their any solution over this repetation?
I have one more problem. Their is a form in which their are three blocks. I want to insert data into only one table which belongs to one of this blocks. By means of button I want to commit the data.But I don't want the data to be inserted in to other blocks.what property of remaining blocks to be set?
reply soon. Thanks for you valuable suggestion about the vertical menu creation

[Updated on: Mon, 22 September 2008 01:59]

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #349726 is a reply to message #349504]

Mon, 22 September 2008 19:55

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

If you want the same objects in multiple forms then create them in a reference form, place them in an object library and then reference the necessary objects in your working form.

If you only want to use one block then either only have one block in your form or only put data into the one block in which you are interested.

David

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #350612 is a reply to message #349726]

Thu, 25 September 2008 10:42

KULKARNI ONKAR
Messages: 12
Registered: September 2008
Location: INDIA

Junior Member

Thanks for giving me this idea.It really worked.Now the problem is I created a records group on query.For this I created a table and inserted values in it logically.But the nodes generated are coming repeatedly.please send me a table script for the same.

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #350663 is a reply to message #350612]

Thu, 25 September 2008 18:36

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Did you remember to remove the old entries?

David

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #351149 is a reply to message #350663]

Mon, 29 September 2008 09:28

KULKARNI ONKAR
Messages: 12
Registered: September 2008
Location: INDIA

Junior Member

Dear sir,I want a query for the tree item.Send me any sample query .Because the query I used ,at runtime all the options comes under resp. nodes and then they comes individually Embarassed

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #351207 is a reply to message #351149]

Mon, 29 September 2008 19:45

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you reviewed all the threads in this forum associated with 'hierarchy' and 'tree'?

David

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #351374 is a reply to message #351207]

Tue, 30 September 2008 09:35

KULKARNI ONKAR
Messages: 12
Registered: September 2008
Location: INDIA

Junior Member

Yes Sir,but I was unable to find a right query which can be used to create a record group and then populate the tree. I used my logic but the problem is after all nodes ,all subnodes comes at bottom of the tree.

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #351447 is a reply to message #351374]

Tue, 30 September 2008 20:31

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Post your code, the script you are using to define your table (or use TOAD to display such a script), and at least five records from that table as 'insert' statements (again use TOAD to do this).

David

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #352139 is a reply to message #351447]

Mon, 06 October 2008 05:27

KULKARNI ONKAR
Messages: 12
Registered: September 2008
Location: INDIA

Junior Member

Hi Sir,I want to know what select statement the form fires when where clause is set using set_block_property('default_where')..
I want to query a block conditionally.
( condition 1
and cond2
cond 3)
and (con1
or con2
or con3)
How can I do this,Because if straight away if write this code in where clause it does not fetches the record according to condition.
suppose I want to write this code on where clause of block

cpncod = :di_isinpaymst.cpncod and paydat= :di_isinratmst.paydat
(datablock item datatype varchar) (datablock item datatype date)

Please reply soon.I am waiting for you.

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #352272 is a reply to message #352139]

Mon, 06 October 2008 23:00

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Does the 'select' statement work in SQL*Plus? Do you have the right datatypes? Do you have a value in both ':di_isinpaymst.cpncod' and ':di_isinratmst.paydat'? If one is 'null' then you will have to use an 'NVL' to get the 'empty side' to select all records.

David

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #352326 is a reply to message #352272]

Tue, 07 October 2008 02:26

KULKARNI ONKAR
Messages: 12
Registered: September 2008
Location: INDIA

Junior Member

It works in sql*plus.I have all the data inthis two columns of the table.But the problem is if I write this code in where clause
set_block_property('',default_where,'cpncod = :di_paymst and paydat :=:di_paydat');
It does not consider the and condition,it fetches the rows either one or both the conditions are true.

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #352459 is a reply to message #352326]

Tue, 07 October 2008 17:32

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

In which trigger are you executing this statement?

Have you tried placing this clause in the 'default_where' in the Forms Builder?

David

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #353579 is a reply to message #352459]

Tue, 14 October 2008 04:15

KULKARNI ONKAR
Messages: 12
Registered: September 2008
Location: INDIA

Junior Member

Good afternoon sir, I solved that problem by using chr(39)on both sides of that varchar2 items.
Now I want some text to be blinking and scrolling . I am using timer for this. Blinking is done properly but the scrolling is not . I am setting the xpos and ypos parameters of the text items.But as you know you have to write code on both i.e. when new form instance/when button pressed and when timer expired.I used a varible whose count will be increased and that count is submitted to xpos of item. How can i use this with populated value in when timer expired trigger. Smile

Report message to a moderator

Re: HOW TO CREATE A VERTICAL MENU [message #353996 is a reply to message #353579]

Thu, 16 October 2008 00:55

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I strongly suggest opening a new thread for a new question.

Search this forum for 'blink' or 'blinking' and 'scroll' or 'scrolling'.

David

Report message to a moderator

Previous Topic:	How to view HTML text in Forms
Next Topic:	Image not saving

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 01:11:10 CST 2025