Using JMP 17 we have been a bit surprised to see what happens in detail with the above preference set, i.e. when performing a SQL Query, the connection string is removed (and not hidden like JMP16) in the result table. When starting the table script "Modify Query", the query builder opens, and we can look at the query, but pressing the "Execute Query" leads only to a generic "Error running SQL Query".
I understand, that removing the connection string is a security feature to not distribute passwords, server names etc.
And the good thing is, that the query definition (SQL) is still available.
This is my proposal:
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.