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; } } }

Run Query in background

Jackie_

Hi,

Is it possible to add <<Run background to "Execute SQL( ODBC, SQL, "table" )"?

I am aware that it works with "New SQL query", not sure if works with Execute sql.

Accepted answers

All comments

jthi

I think you can only use it with New SQL Query().

Is there a specific reason for not using New SQL Query()? It is the preferred method of performing SQL queries from JMP.

hogi

With New SQL Query, there is no possibility to debug the query, right?
No command to get the error message from the server?

Jackie_

@jthi
I have a JSL based SQL dashboard and am using 'Execute SQL' pretty much in the entire code so it would be ideal to add an extra Syntax "<<Run background" than modifying the entire code structure.

jthi

I don't think that is possible with Execute SQL, so you would either change to New SQL Query or continue running the queries in the foreground like Execute SQL always does.

I have also written almost all of my SQL queries in JMP using Execute SQL syntax, but I'm slowly changing to New SQL Query() where I can, even though the syntax for it is in my opinion fairly bad, it is much more difficult to use and it doesn't have good documentation... but I'm working out all the kinks in hopes that it will be improved in the future.

Jackie_

I agree not the best