Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Multi row blocks
"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