SqlDbx Forum

SqlDbx

You are not logged in.

#1 2019-05-20 06:10:37

Alex77
Member

Don't display results of commands after "light" errors

Hello

I use SQlDbx for Sybase ASE 12.5.1

There are kind of errors in Sybase ASE thats not realy stop the script.
The problem: SQLDbx still process the commands after such an error, but  doesn't display query results, messages and erros.

script example:

create table #TempTable (Flag int)

print '<<< Message 1 >>>'    
insert #TempTable(Flag) values(1)
select 'step1' as step, * from #TempTable

RaisError 40001 'Error (User)'

print '<<< Message 2 >>>'    
update #TempTable set Flag = 0
select 'step2' as step, * from #TempTable
go

print '<<< Message 3 >>>'    
select 'step3' as step, * from #TempTable
go

SQLDbx output

step  Flag
----- ----
step1    1

<<< Message 1 >>>
Error (40001) Error (User)


Rows affected (1) Time (0.016 s)

step  Flag
----- ----
step3    0

<<< Message 3 >>>


Rows affected (1) Time (0.000 s)

isql output

Password: 
<<< Message 1 >>>
(1 row affected)
 step  Flag        
 ----- ----------- 
 step1           1 

(1 row affected)
Msg 40001, Level 16, State 1:
Server 'MyServer', Line 7:
Error (User)
<<< Message 2 >>>
(1 row affected)
 step  Flag        
 ----- ----------- 
 step2           0 

(1 row affected)
<<< Message 3 >>>
 step  Flag        
 ----- ----------- 
 step3           0 

(1 row affected)

"Step 2" message, update and select are executed both SQLDbx and isql? but only isql display the results.

Is there any option in sqldbx to correct this output?

BTW not only RaisError doesn't stop the script, but also some system errors too.

Offline

Board footer

Powered by FluxBB