I have a quick follow-up question. When i run the script that includes my sql script (when i select "Click Here When FInished") that window appends with wafer list. That is working as intended however It appears it is stopping right before the gbirl << delete;
hay = New Window( "Test Database Tools",
V List Box(
V List Box(
Text Box( "Welcome to the Test Database",
<< Set Font Size( 20 ),
<< Set Width( 1920 ),
<< Justify Text( "Center" )
),
Spacer Box(
Size( 10, 15 )
),
H List Box(
bb = Border Box( Left( 15 ), Right( 10 ), Top( 10 ), Bottom( 10 ), Sides( 15 ),
V List Box(
lineup1 = Lineup Box(
N Col( 1 ),
V List Box(
lineup2 = Lineup Box(
N Col( 1 ),
Text Box( "Select Desired Test Dates",
<< Set Font Size( 20 ),
<< Justify Text( "Center" )
),
Spacer Box(
Size( 5, 15 )
),
H Splitter Box(
Border Box( Left( 15 ), Right( 10 ), Top( 10 ), Bottom( 10 ), Sides( 15 ), StartDate = Calendar Box(
<< Set Function(
Function(
{f1},
sqlStartA = StartDate << Get Date()
)
)
)
),
Border Box( Left( 15 ), Right( 10 ), Top( 10 ), Bottom( 10 ), Sides( 15 ),
EndDate = Calendar Box(
<< Set Function(
Function(
{f2},
sqlendA = EndDate << Get Date()
)
)
)
)
)
)
),
Spacer Box(
Size( 5, 15 )
),
bb1 = Button Box( "Click Here When Finished",
sqlstart = Format( sqlstartA, "yyyy-mm-dd" );
sqlend = Format( sqlendA, "yyyy-mm-dd" );
Show( sqlstart, sqlend );
lineup1 << Append(
V List Box(
loaddata = Button Box( "Load Test Data",
doListChoice; // converts single lot to multiple for purpoose of sql data pull
doLoadWafer; // sql scipt to pull in test data
),
Spacer Box(
Size( 5, 15)
),
Panel Box( "Select Wafer(s)",
doLotList,
Lotlistbox = Check Box( LotList, Beep() ), // lot list based on date selection
LotListBox << Get Selected;
)
)
),
// gbirl << Append( gb );
gbirl << delete; // Stops right before it gets to this step in the code (assumption)
// dt = open( "$SAMPLE_DATA/big class.jmp",invisible); // Your inserted script
// Replaced your Bivariate with my Graph Plot
gbirl = V List Box(
::dt_testdata_ss << Graph Builder(
Show Control Panel( 0 ),
Show Legend( 0 ),
Variables(
X( :FREQ_GHz ),
Y( :IRL ),
Group X( :wafer_number ),
Overlay( :RowCol )
),
Elements( Smoother( X, Y, Legend( 11 ) ) ),
Local Data Filter(
Add Filter(
columns( :wafer_number, :trmode, :channel ),
Display( :channel, Check Box Display )
)
)
)
);
gbirlvlb << append(gbirl);
),
Spacer Box(
Size( 5, 15 )
)
)
)
),
// The below scripts are place holders for now
Tab Box(
"Graph Plot",
V Splitter Box(
H Splitter Box(
gbirlvlb = V List Box(
gbirl = Graph Box()
),
gbgain = Graph Box(),
gborl = Graph Box()
),
H Splitter Box(
gbnf = Graph Box(),
gbgaindb = Graph Box()
)
),
"Distributions",
Text Box( "Place"),
"Wafer Map",
Text Box( "Place" )
)
)
)
)
);