SqlDbx Forum

Timo

Member

Putting text in result tab

I would like to be able to put text in the resulttab between the results of the executed queries.

It would be nice if the text can use variables etc.

Cheers.

Timo

sqldbxhelp

Administrator

Re: Putting text in result tab

I am not sure what you mean.
Please provide more information.

Timo

Member

Re: Putting text in result tab

When I submit multiple query statements the resulttab is filled with the results of the submitted qeuries.
Because I have to test a lot stored procedures I would like to add text like "this is the result of query x" between
the output of the submitted queries so that I don't have to count the output to know to which result I am looking.

If use print the text is send to the messages tab thus useless for what I want.

example of what I want below:

------------
/ resulttab
----------------------------------------------------------------------------------------
This is the result of q: A

1 jkhkhj jkhkhkh jkh khsd  oiu weor oidfuasd r iofuowe saioufsdo r
2 fjklsda  sdfh  sdfjk  asdfjkh sdfjk ajsdfjk hsdf jkasdf f

-----------------------------------------------------------------------------------------
This is the result of q: B

1 jkhkhj jkhkhkh jkh khsd  oiu weor oidfuasd r iofuowe saioufsdo r
2 fjklsda  sdfh  sdfjk  asdfjkh sdfjk ajsdfjk hsdf jkasdf f

-----------------------------------------------------------------------------------------
End of test

I hope this clarifies it.

Cheers Timo

sqldbxhelp

Administrator

Re: Putting text in result tab

You can do something like this now.
Make sure that menu item Results->Include messages/errors checked.
Then something like this will get you results you want
select *from A
print 'results from A'
select *from B
print 'results from B'