SqlDbx
You are not logged in.
Pages: 1
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
Offline
I am not sure what you mean.
Please provide more information.
Offline
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
Offline
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'
Offline
Pages: 1