cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Jackie_
Level VI

Run Query in background

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.

 

5 REPLIES 5
jthi
Super User

Re: Run Query in background

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.

-Jarmo
hogi
Level XII

Re: Run Query in background

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

Jackie_
Level VI

Re: Run Query in background

@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
Super User

Re: Run Query in background

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.

-Jarmo
Jackie_
Level VI

Re: Run Query in background

I agree not the best