- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Run Query in background
I agree not the best