SqlDbx
You are not logged in.
Pages: 1
This is new to 3.47. Can I get a description of the functionality? I want to decide if its worth it to move from 3.44 to 3.46 OR wait for 3.47. Thanks.
Offline
You can download latest version and check "Script commands" topic in help file.
Offline
There only three commands listed in the help. Is that all that there is access to at this time?
Offline
This is a new feature. We do plan to extend it in the future.
If you have any suggestions then we are listening
Offline
Just came up with one. cmd results = clear. When executed, clears the current result buffer. Used to help monitoring. For example:
declare @loops int
select @loops = 1000
while @loops > 0
begin
select getdate()
select * from my_status_table where end_ts is null
select @loops = @loops - 1
cmd results = clear
waitfor delay "00:00:30"
end
Without the clear, you have to scroll to the bottom every time a new result shows up.
OR
cmd results = at bottom
so that the results buffer does not reset to the top after each set shows up.
Offline
cmd do not look like executable statements but advisory or parameter setting statements. Therefore, I'd go with the
cmd results = at bottom
implementation.
Offline
Unfortunately it can not be implemented this way.
The whole batch has to be sent to Sql Server and line
with cmd will cause an error. Currently cmd has to be
a separate batch.
Offline
Pages: 1