Print Causing Problems from ISQL

[power97]

Hi,
I am calling a stored procedure using isql as part of an overnight script. If I run into an error during the loop I fire a stored procedure that inserts a record into the error logging table. However , what I have found is that if I have a print statement in my error log stored procedure it causes the isql to fail returning a 1 even though the "master" procedure is returning a 0.
If I run the "master" stored procedure on it's own it seems to work fine but when run from ISQL the "print" causes an error. Any ideas ?

Thanks

http://www.musicianwanted.ca

 

[power97]

Hi,
Never mind , I figured this one out .

http://www.musicianwanted.ca