Focal Point
[SOLVED]Overlaying a read/write grid with a drop

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/879102113

December 07, 2009, 09:58 AM
Håkan
[SOLVED]Overlaying a read/write grid with a drop
Is it possible to put a drop or a listbox on top of a read/write grid in Maintain (7.6.4)? Maybe I'm doing something wrong, but even if I set the z-index of the grid to -1 and the z-index of the listbox to 99, the grid is on top of the listbox. Any clues?

Tia
Håkan

This message has been edited. Last edited by: Håkan,


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)
December 11, 2009, 01:48 PM
Kerry
Hi Hakan,

Please take a look at the following presentation, which has what you are asking for and some additional tips/techniques:
WebFOCUS Maintain - Enhancing Objects with JavaScript

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
December 11, 2009, 02:59 PM
John_Edwards
I'll add the following -- the Maintain Grid is an ActiveX control based on the UltimateGrid widget. There is a lot of additional UltimateGrid capability that is not documented in WF. It's reference material is here --> http://www.codeproject.com/KB/...he%20Ultimate%20Grid

My best guess is that IB will not bless all of the functions the widget presents, but a LOT of them work and make your look and feel much more capable. It's well worth your time to have that url in your back pocket.

For what it's worth that drop-down box is new to me. I would have loved to have known about it eight months ago.

J.



December 12, 2009, 03:51 PM
Maintain Wizard
Håkan

I hope my presentation was helpful. The Active X grid is always on top. As you found out, setting the z-index doesn't help. However, it's pretty easy to add the List box (and even a radio button) to a grid cell. Let me know if you have any questions.

We are in the process of putting the finishing touches on a JavaScript Grid. The NICE thing is that it will run on all browsers and not have security issues like the Active X grid. However it does not yet have all the current bells and whistles.

Mark
December 14, 2009, 04:13 AM
Håkan
Mark,

the listbox in the grid is neat, but how do you populate the list from a table? One other thing, what's the time frame for the JavaScript grid?

Håkan


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)
December 14, 2009, 09:45 AM
Maintain Wizard
Ok - To create a dynamic list in a grid list, you need to get the values and place them as a deliminated list in an edit box on the form. You can then grab them and place them in the drop down box.

Build a DataStk dynamically as:
- EXEC procedure INTO DataStk;

Then create the DynamList:

Create an invisible box "List1" on the form and compute all the dynamic codes into STRING with "," separating each value:

Compute R=1;
Compute List1/A25= ' ';
 repeat DataStk.FocCount
 compute List1 = List1 || DataStk(R).value | ',';
 compute R=R+1;
 endrepeat
Reason for ',' is that in FOCUS/HTML cannot use "\n" (carriage control).
*** Note - this limitation may have changed. You may just want to try \n
 
 
function OnGrid1_OnRowChange ( long row, long newRow)  {
 
var DynamList=document.Form1.List1_Edit.value;
// Replace the "," with "\n"
var myRegExp = /,/gi;
DynamList=DynamList.replace(myRegExp,"\n");
Form1.Grid1.GetCell(2,newRow);
Form1.Grid1.QuickSetCellType(2, newRow, 1);
Form1.Grid1.QuickSetLabel (2, newRow, DynamList);
}    

Remember, you will have to do this for the focus trigger as well. I hope this helps.

The JavaScript grid is scheduled for 7.7 which is early 2010, but it will only have basic functionality at that time.

Mark 
December 17, 2009, 01:29 PM
Håkan
Thanx Mark, I'll try it when I get the time. However, I do think I'll prefer the JS grid to become more browser independent.


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)