[freetds] (-1 rows affected)

Thompson, Bill D (London) bill_d_thompson at ml.com
Thu Nov 6 09:12:16 EST 2003


Hi,

Freetds snapshot 30th October with my changes applied ( the code from which
my patch of the 31st October was generated )
sqsh 1.7 

Test #1
-----------

1>
1> create table #bill (col1 int, col2 char(4) )
2>
1> insert #bill values (1, 'A')
2>
(1 row affected)
1> update #bill set col1 = 2
2>
(1 row affected)
1> update #bill set col1  = 3 where col2 = 'B'
2>
(0 rows affected)
1>
1> update #bill set col1  = 3 where col2 = 'B'
2> update #bill set col1 = 2
3>
(0 rows affected)
(1 row affected)
1>
1> create table #pants (col1 int)
2>
1>

All looks OK to me.

BTW sp_help executed through sqsh doesn't generate ANY rows affected
messages for me....

Bill

> -----Original Message-----
> From:	Lowden, James K [SMTP:LowdenJK at bernstein.com]
> Sent:	05 November 2003 17:22
> To:	'TDS Development Group'
> Subject:	[freetds] (-1 rows affected)
> 
> Bill, 
> 
> sqsh still displays "(-1 rows affected)" when executing, say, "sp_help".
> Do
> you know why that is, or whether the problem lies in libtds or ct-lib?
> Or
> sqsh?  
> 
> It'd be nice to fix this for 0.62.  
> 
> --jkl
> 
> -----------------------------------------
> The information contained in this transmission may contain privileged and
> confidential information and is intended only for the use of the person(s)
> named above. If you are not the intended recipient, or an employee or
> agent responsible for delivering this message to the intended recipient,
> any review, dissemination, distribution or duplication of this
> communication is strictly prohibited. If you are not the intended
> recipient, please contact the sender immediately by reply e-mail and
> destroy all copies of the original message. Please note that we do not
> accept account orders and/or instructions by e-mail, and therefore will
> not be responsible for carrying out such orders and/or instructions.
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds



More information about the FreeTDS mailing list