Posted by lvpaul on 10/01/73 11:28

Thanks, but it doesn´t work

This is my script - its a file c:\test.sql

declare @errorcode int
select * from abc
SET @errorcode = @@error
--writing log
insert adaten.dbo.loghist(logdatum,loginfo,logfehler,saetze)
values (getdate(),'test',@errorcode,25)

The table "abc" don´t exist.

If I call the script

osql /E /n /ic:\test.sql (with or without /b) the insert anweisung
instruction won´t be executed.

I want something like ON ERROR RESUME NEXT. Is this possible ?

Thanks
aaapaul

[Back to original message]