nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Closing SQL query after running

Polyabc

Hello,

I have a JSL script that calls for different SQL queries. After the data table is complete, I want to close the queries. Is this possible?

query = Close( "C:\\example.jmpquery" )

does not work.

Thanks.

Accepted answers

tom_abramov

q1 = Open("C:\myQuery.jmpquery");
q1 << Run Foreground;
q1 << Close Window();

All comments

txnelson

See

Close Database Connection

in the Scripting Index.

I believe that

Close Database Connection( query );

should work

Polyabc

Thanks!

What I want to know if it is possible to close the queries themselves, not necessarily the connection to the database. At the end of the running the script I'm left with 10 open queries which I don't need. Any idea how to close the individual queries?

Mark_Bailey

I assume that you mean by 'query' the resulting JMP data tables. If so, then this example should help you.

// an open query
 query = Open Database( ... );


// close query
Close( query, No Save );

Polyabc

Thanks very much for your reply.

I meant the query itself, not the data table. the query that is opened with Select File > New > Database Query.

Is there any way to close this query itself?

Thanks.

tom_abramov

q1 = Open("C:\myQuery.jmpquery");
q1 << Run Foreground;
q1 << Close Window();

Polyabc

Thanks! this works!