SqlDbx
You are not logged in.
How do you tie/connect/attach script tab 1 to results tab 1, so every time I execute a script in script tab 1 those results are put in results tab 1 automatically?
Thank You!
Offline
Hello,
There no setting which allows to do exactly this thing.
What you can try is to use script commands related to tab management
Offline
This is how I do it:
cmd result_current = Tab1
go
cmd result_name = Tab1
SELECT * FROM MyTable ;
go
Offline
I am assuming this does not work with SQL Server?
I get the following error:
cmd result_current = Tab1
go
cmd result_name = Tab1
SELECT 'Hello';
go
1, Incorrect syntax near '='.. Native error: 102. SQLSTATE: 42000. Severity 15. MsgState 1. Line 1.
3, Incorrect syntax near '='.. Native error: 102. SQLSTATE: 42000. Severity 15. MsgState 1. Line 1.
Offline
my apologizes, I was actually executing the following, either way the errors are the same.
cmd result_new = Tab1
go
cmd result_name = Tab1
SELECT 'Hello';
go
Offline
I'm on Microsoft SQL Server 2017 running SQLDBX 6.02 Professional. I ran your script and did not receive any errors.
Offline
Thank you for verifying this for me.
I have SqlDbx 6.12 Personal Edition. This functionality must not be available with the Personal Edition, I did not see it listed specifically.
It is so difficult to evaluate a software product when you can't test the features you think you would utilize.
Offline