Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Multi row blocks

Re: Multi row blocks

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sun, 11 Apr 2004 06:49:44 -0400
Message-ID: <nqGdnb6MMY9Ov-TdRVn-vw@comcast.com>


"Julesm" <julesm_at_ip242yh.plus.com> wrote in message news:IJ_dc.29032$h44.4133683_at_stones.force9.net...
| Hi Mark,
|
| Thanks for that comprehensive reply.
| I'm not a forms programmer, so wont pretend to understand some all of what
| you say.
| I needed to ask the question, as our main forms guru says it simply cant
be
| done.
|
| In a nut shell, we simply want ot have full (manual) control over the
| contents of a grid like structure, (presumably made with a MRB), with some
| cells empty, and some rows being able to show/hide them selves depending
on
| the actions of the user.
| The best way I can describe that would be similar would be the interaction
| with a Treeview, whereby one column of the grid would contain a + or -
| depending upon the current show/hide state of related (child data).
|
| If all this seems like too much work, is there a simple way to get
active-x
| grids into 9i forms?
|
| Hope this makes sense, I'm writing this very late, and my mind is all
foggy,
| although that could be thee wine :)
|
| Regards
| Jules
|

jules,

your forms guru may need to go back to the mountain for a refresher ;-)

what you want to do is certainly very possible, in a number of ways

my previous post describes the way to do a grid-like structure with standard oracle components

the additional information you provide makes me wonder if using form 9i's built-in Hierarchical Tree control might be part of the solution -- it's not an editable grid, but it has the built-in show/hide functionality of a typical tree-structure, and can be synchronized with a detail view that is editable

active-x is out in 9i, since 9i does not run client-server

however, you can add a javabean to implement a grid -- go to http://asktom.oracle.com and search for 'javabean forms' for an example of implementing a javabean in forms (you -- or your guru -- can also search otn.oracle.com for more info on java in forms 9i)

;-{ mcs Received on Sun Apr 11 2004 - 05:49:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US