cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.
  • See how to access JMP Marketplace - and - find, create & share add-ins to extend your JMP. Watch video.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar
0 Kudos

Proper information in Log window when executing SQL query

What inspired this wish list request?

 

JMP expects an actual table to be returned in a SQL query. So, if the SQL query contains create temp table, we must add "SET NOCOUNT ON" so the Transact-SQL statement does not try to return the rows impacted by the query. If there is not this line in the beginning of the SQL query, JMP just can't return any result and there is not any meaningful feedback in GUI or Log window.

 

 

What is the improvement you would like to see? 

Add meaningful feedback in GUI or Log window.

 

Why is this idea important? 

We need to have a proper response for any implementation, right?

 

 

1 Comment
Status changed to: Acknowledged

Thank you for taking the time to share this feedback!