topic Re: Run Query in background in Discussions

Run Query in background

Jackie_ — Tue, 23 Jan 2024 15:21:58 GMT

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.

Re: Run Query in background

jthi — Tue, 23 Jan 2024 18:03:59 GMT

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.

Re: Run Query in background

hogi — Tue, 23 Jan 2024 22:08:33 GMT

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

Jackie_ — Wed, 24 Jan 2024 13:42:14 GMT

@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.

Re: Run Query in background

jthi — Wed, 24 Jan 2024 19:45:26 GMT

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

Jackie_ — Thu, 25 Jan 2024 13:56:56 GMT

I agree not the best