718173_en-US

liliconcom

Run Query in background

Hi,

 

Is it possible to add <

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

 

Automation and ScriptingRe: Run Query in background

I agree not the best

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.

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 "<

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?

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.