Home » Developer & Programmer » Forms » HOW TO CREATE A VERTICAL MENU (FORM 9I)
HOW TO CREATE A VERTICAL MENU [message #348383] Tue, 16 September 2008 10:31 Go to next message
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
Re: HOW TO CREATE A VERTICAL MENU [message #348769 is a reply to message #348383] Wed, 17 September 2008 23:00 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: HOW TO CREATE A VERTICAL MENU [message #349269 is a reply to message #348769] Fri, 19 September 2008 10:14 Go to previous messageGo to next message
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
Re: HOW TO CREATE A VERTICAL MENU [message #349448 is a reply to message #349269] Sun, 21 September 2008 21:11 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: HOW TO CREATE A VERTICAL MENU [message #349504 is a reply to message #349448] Mon, 22 September 2008 01:57 Go to previous messageGo to next message
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: HOW TO CREATE A VERTICAL MENU [message #350612 is a reply to message #349726] Thu, 25 September 2008 10:42 Go to previous messageGo to next message
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.
Re: HOW TO CREATE A VERTICAL MENU [message #350663 is a reply to message #350612] Thu, 25 September 2008 18:36 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Did you remember to remove the old entries?

David
Re: HOW TO CREATE A VERTICAL MENU [message #351149 is a reply to message #350663] Mon, 29 September 2008 09:28 Go to previous messageGo to next message
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
Re: HOW TO CREATE A VERTICAL MENU [message #351207 is a reply to message #351149] Mon, 29 September 2008 19:45 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you reviewed all the threads in this forum associated with 'hierarchy' and 'tree'?

David
Re: HOW TO CREATE A VERTICAL MENU [message #351374 is a reply to message #351207] Tue, 30 September 2008 09:35 Go to previous messageGo to next message
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.
Re: HOW TO CREATE A VERTICAL MENU [message #351447 is a reply to message #351374] Tue, 30 September 2008 20:31 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: HOW TO CREATE A VERTICAL MENU [message #352139 is a reply to message #351447] Mon, 06 October 2008 05:27 Go to previous messageGo to next message
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.
Re: HOW TO CREATE A VERTICAL MENU [message #352272 is a reply to message #352139] Mon, 06 October 2008 23:00 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: HOW TO CREATE A VERTICAL MENU [message #352326 is a reply to message #352272] Tue, 07 October 2008 02:26 Go to previous messageGo to next message
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.
Re: HOW TO CREATE A VERTICAL MENU [message #352459 is a reply to message #352326] Tue, 07 October 2008 17:32 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: HOW TO CREATE A VERTICAL MENU [message #353579 is a reply to message #352459] Tue, 14 October 2008 04:15 Go to previous messageGo to next message
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
Re: HOW TO CREATE A VERTICAL MENU [message #353996 is a reply to message #353579] Thu, 16 October 2008 00:55 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: How to view HTML text in Forms
Next Topic: Image not saving
Goto Forum:
  


Current Time: Thu Dec 08 18:09:17 CST 2016

Total time taken to generate the page: 0.28811 seconds