Am I going crazy or How is that possible? - Need help troubleshooting weird behaviour

miguello

Issue in my App that I was troubleshooting the whole day. I narrowed it down to this very qeird behaviour. Unless I'm missing something, this should not be this way.

I have two tables opened: "Baseball" and "Basketball".

I have this script:

	Clear Log();
	//dt_current=Data Table("Basketball");
	/*Two tables opened: Baseball and Basketball. The table named "Basketball" is selected as current table*/
	dt_working=Data Table("Baseball");
	
	Show("This is the dt_working table:");
	Show(dt_working<<Get Name());
	colNamesList = dt_working << Get Column Names;
	show("Columns names:");
	show(colNamesList);
	colListX = Col List Box (dt_working, all, width(250), maxSelected(1));
	show("This is what dt_working still is:");
	show(dt_working<<Get Name());
	show("But this is what I got in Col List Box:");
	show(colListX<<Get Items);
	
	

Obviously, I'm trying to create a Col List Box with columns from Baseball Table.

But this is what my log (and the rest of the App) showing me:

"This is the dt_working table:";
dt_working << Get Name() = "Baseball";
"Columns names:";
colNamesList = {Player, Batting};
"This is what dt_working still is:";
dt_working << Get Name() = "Baseball";
"But this is what I got in Col List Box:";
colListX << Get Items = {"School", "CSN", "Durham Sun", "Durham Herald", "Washington Post", "USA Today", "Sports Magazine", "In Sport", "UPI", "AP", "Sports Illustrated"};

For some reason even though I specified dt_working to be Baseball and said that Col List Box is created using table dt_working, it populates Col List Box with columns from the current data table that I chose in the tool bar up top.

 

Another app that generally has different code but that particular part is exactly the same works differently and how I intended it to work. Can somebody help me troubleshoot it further? Why owuld it populate Col List Box not form the table I told it to populate, but from the current table?

 

In the long run I'm trying to display columns from tables that I select in a different List Box. A similar functionality in another app works just fine. Here no matter what table I click (and run a code similar to one I cited) it always shows columns from the table selected up top.

 

 

Thanks, 

M.

 

log.png

code.png

gzmorgan0

I would call this a bug. I got caught by this last year.  However, there is a solution.  The problem is that ColListBox is not evaluating or parsing the table reference dt_working.   My recommendation is to use the syntax ColListBox( Data Table(dt_working << get name), .... or to make the intended table the current data table, when colListX is created. 

hmmm my JSl is wrapping. Script attached. 

 

open("$Sample_data/Basketball.jmp");<BR />open("$Sample_data/Baseball.jmp");<BR /><BR />Clear Log();<BR /> //dt_current=Data Table("Basketball");<BR /> /*Two tables opened: Baseball and Basketball. The table named "Basketball" is selected as current table*/<BR /> dt_working=Data Table("Baseball");<BR /> <BR /> Show("This is the dt_working table:");<BR /> Show(dt_working<<Get Name());<BR /> colNamesList = dt_working << Get Column Names;<BR /> show("Columns names:");<BR /> show(colNamesList);<BR /> show(current data table()); //Baseball<BR /> <BR /> colListX = Col List Box (all, width(250), maxSelected(1));<BR /> show(colListX<<Get Items); //Baseball aka current data table()<BR /><BR /> //_______________________________________________________<BR /> <BR /> Write("\!N" ||Repeat("_",60)||"\!N");<BR /> <BR /> //make Basektball current <BR /> <BR /> current data table(Data Table("Basketball"));<BR /> <BR /> colListX = Col List Box (dt_working, all, width(250), maxSelected(1));<BR /> show(colListX<<Get Items); //Basketball aka current data table()<BR /><BR /> colListX = Col List Box (NameExpr(dt_working), all, width(250), maxSelected(1));<BR /> show(colListX<<Get Items); //Basketball aka current data table()<BR /><BR /> colListX = Col List Box (Data Table("Baseball"), all, width(250), maxSelected(1));<BR /> show(colListX<<Get Items); //Baseball<BR /> <BR /> <BR /> colListX = Col List Box (Data Table(dt_working<<get name), all, width(250), maxSelected(1));<BR /> show(colListX<<Get Items); //Baseball <BR /><BR /><BR /> Eval( <BR /> Parse( EvalInsert("colListX = ColListBox( ^dt_working^, all, width(250), maxSelected(1));") )<BR /> );<BR /> wait(0);<BR /> show(colListX<<Get Items); //Baseball<BR />

 

 

 

ColListBox_DataTableIssue.jsl