SqlDbx
You are not logged in.
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