getting rid of the return status of a stored procedure 
Author Message
 getting rid of the return status of a stored procedure

What status line? When I run a stored procedure in isql (I
normally use the ODBC based osql), I use the following
switches:

-h-1: Don't print headings
-n: remove line numberings

Is this what your meant?

Mark.
www.allisonmitchell.com

Quote:
>-----Original Message-----
>When I execute a stored procedure with isql then it
>returns me the number of row affected and the return
>status. If I use "set nocount no", then I get rid of the
>number of row affected, but I want to know how to get rid
>of the status line and I don't know how to do that.

>Cheers,

>JULIEN
>.



Sun, 29 Aug 2004 20:52:20 GMT
 getting rid of the return status of a stored procedure

When I run a stored procedure such as sp_who for instance,
I have one line of header (the field's names), the rows,
one line written: (19 rows affected) , and one line
written: (return status = 0). The last line tells if the
stored procedure went fine or not. When I set nocount to
on, then I can get rid of the line (19 rows affected), but
it still remain the line (return status = 0). And I want
to find a way to get rid of this line. You give me optins
like '-h-1' and '-n', but I don't get where to put them.
Can you tell me more please, becasue it might solve my
problem.
Cheers,

JULIEN

Quote:
>-----Original Message-----
>What status line? When I run a stored procedure in isql
(I
>normally use the ODBC based osql), I use the following
>switches:

>-h-1: Don't print headings
>-n: remove line numberings

>Is this what your meant?

>Mark.
>www.allisonmitchell.com

>>-----Original Message-----
>>When I execute a stored procedure with isql then it
>>returns me the number of row affected and the return
>>status. If I use "set nocount no", then I get rid of the
>>number of row affected, but I want to know how to get
rid
>>of the status line and I don't know how to do that.

>>Cheers,

>>JULIEN
>>.

>.



Sun, 29 Aug 2004 21:24:02 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. stored procedures: return codes and return status with rdo

2. Getting rid of the IDENTITY property on a column withou getting rid of the column

3. Getting rid of read only status on Foxpro database used in Visual Basic 6 application

4. how to set the return status for an extended stored procedure

5. Stored Procedure, Return status, VBSQL

6. return status from stored procedure

7. Stored procedures and (return status = 0)

8. Getting Error Message return from a stored procedure!

9. Having problem getting return code from stored procedure

10. problem getting return value from stored procedure

11. Getting a Return Value from a SQL Stored Procedure in ASP

12. Getting stored procedures return value.


 
Powered by phpBB® Forum Software