SqlDbx Forum

SqlDbx

You are not logged in.

#1 2021-06-02 19:09:42

gtejas
Member

Permanently tie script tab 1 to results tab 1

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

#2 2021-06-03 19:01:08

sqldbxhelp
Administrator

Re: Permanently tie script tab 1 to results tab 1

Hello,

There no setting which allows to do exactly this thing.
What you can try is to use script commands related to tab management

http://www.sqldbx.com/Help/scr/html/ScriptCommands.htm

Offline

#3 2021-06-04 17:56:37

TimD
Member

Re: Permanently tie script tab 1 to results tab 1

This is how I do it:

cmd result_current = Tab1
go
cmd result_name = Tab1
SELECT * FROM MyTable ;
go

Offline

#4 2021-06-08 10:00:15

gtejas
Member

Re: Permanently tie script tab 1 to results tab 1

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

#5 2021-06-08 10:05:27

gtejas
Member

Re: Permanently tie script tab 1 to results tab 1

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

#6 2021-06-08 10:35:25

TimD
Member

Re: Permanently tie script tab 1 to results tab 1

I'm on Microsoft SQL Server 2017 running SQLDBX 6.02 Professional. I ran your script and did not receive any errors.

Offline

#7 2021-06-08 10:53:28

gtejas
Member

Re: Permanently tie script tab 1 to results tab 1

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

Board footer

Powered by FluxBB