cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
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?