Subscribe Bookmark RSS Feed

How to make an SQL table Invisible?

isabellet14

Occasional Contributor

Joined:

Jun 30, 2016

I have another "invisible" question. I made an SQL table (from Query Builder) and want to modify my JSL to make that table invisible. I've tried adding "Invisible" to many different places, but none have worked. Is there a different syntax for making a Query Builder table invisible? Here is my code - thanks in advance for the help!

dt1=New SQL Query(

Version( 130 ),

Connection( "JMP" ),

["JMP_Table" =>

"Tablelocation.jmp"

QueryName( "SQLQuery1" ),

Column(

"example",

"t1",

Alias( "exampleAlias" )

Column(

"example2",

"t1",

Alias( "exampleAlias2" ) 

Column(

"example3",

"t1",

Alias( "exampleAlias3" )

From( Table( "JMP_Table", Alias( "t1" ) ) )

) << Run;

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Strange that the invisible keyword is not available here.  Try using << show window(0); that will make your table invisible.  Here's a simple example:

dt = open("$sample_data\Big Class.jmp");

dt <<Show Window(0);


2 REPLIES
Solution

Strange that the invisible keyword is not available here.  Try using << show window(0); that will make your table invisible.  Here's a simple example:

dt = open("$sample_data\Big Class.jmp");

dt <<Show Window(0);


isabellet14

Occasional Contributor

Joined:

Jun 30, 2016

That did it - Thanks so much for the quick help!