Hi Dan,
thanks for the feedback. We will look into that. I know we already mentioned this to you but for the record, we do have a PowerShell connection type which can render basically any output as text or even in a grid:
https://content.royalapplications.com/Help/RoyalTS/V4/index.html?reference_powershellconnection.htm
It's quite easy to create a PowerShell script which connects to a database and executes a query:
https://docs.microsoft.com/en-us/sql/powershell/invoke-sqlcmd-cmdlet
Or using some .net SQL client object:
https://blog.jourdant.me/post/simple-sql-in-powershell
Regards,
Stefan
Thank you, i agree that for just running command with no other "feedback" that would work fine. I would also like a grid view to show SELECT results too so that would be a lot trickier,
You can use a grid view to output the select results using the PowerShell connection type. Once it is shown in the grid, you can do all sorts of stuff, like sorting, filtering, etc.
cheers,
Stefan
Also make sure you check out this blog post:
http://blog.royalapplications.com/2015/06/16/new-feature-powershell-connection/
Should you have any questions, let me know.
Regards,
Stefan
Dan Johns
Something like Oracle's SQL Developer embedded.