How to Extract Values from a Table Box( String Col Edit Box((I was trying to add a table with string col edit boxes based on the users selection. I managed to create the table box but I can't figure out how to extract the values from the String Col Edit Boxes and then once extracted, converted to an SQL String ex.( 'teb', 'Wafer1', 'Wafer2', 'Wafer3' )
Thanks in advance
D
nw = New Window( "test",
vlb = V List Box(
Text Box( "Product Engineering", <<SET font="" size=""></SET>
Re: How to Extract Values from a Table Box( String Col Edit Box((Another helpful tool is the Application Builder. When you click and drag widgets onto the screen you can highlight them and most of the properties show up on the right hand side.
Re: How to Extract Values from a Table Box( String Col Edit Box((I believe the issue that you are having, is that you are looking for Display Boxes that are designed to provide complete solutions. The JMP objects and functions are at a more base level, in that you put together multiple Display Objects and Functions into your unique final application. The advantage of this, is that the final application can be of almost any design you want. The disadvantage is, that the author of such systems needs to spend a significant amount of time learning about the wide variety of objects and functions within the language.Re: How to Extract Values from a Table Box( String Col Edit Box((I agree and have it open as well as the Scripting Guide at all times when i am scripting.. I will go back and browse there..
ThanksRe: How to Extract Values from a Table Box( String Col Edit Box((The Scripting Index is an invaluable resource for this kind of information. Help > Scripting Index. Choose Display Boxes from the dropdown and you'll see all objects and functions for display boxes.
Re: How to Extract Values from a Table Box( String Col Edit Box((I have been searching the Scripting Guide but haven't found much on actually all the formatting options for Display Boxes.. Is there a section / website that has what you can do with what display box?
Thanks in advanceRe: How to Extract Values from a Table Box( String Col Edit Box((Thank you very much.. I was just in the process of attempting to add the tested wafer to the list then convert it to sql format.
Much appreciated
Re: How to Extract Values from a Table Box( String Col Edit Box((concat items is my secret weapon for creating in lists:
wafer = {"ABC", "DEF", "GHI", "JKL"};
nw = new window("test", << modal(),
tbl = Table Box(
seb = String Col Edit Box( "Comparison", wafer )
),
button box("OK",
wafer_list = seb << get;
)
);
show(wafer_list);
// Convert to IN list
wafer_in_list = "('" || concat items(wafer_list, "', '") || "')";
show(wafer_in_list);
From the log window:
wafer_list = {"ABC", "DEF", "GHI", "JKL"};
wafer_in_list = "('ABC', 'DEF', 'GHI', 'JKL')";
Re: How to Extract Values from a Table Box( String Col Edit Box((Thank you, I didn't realize that it was that easy.. I throught you had to assign a variable to each of the boxes..
Re: How to Extract Values from a Table Box( String Col Edit Box((You can get the contents of the string col edit box using something like:
wafer_list = seb << Get;
What do you mean SQL string? You can convert the list to a string using char(wafer_list), but you will need to use something like substitute() to swap the curly braces for parentheses or something, as well as double for single quotes if needed. Should be relatively easy.
