[freetds] (-1 rows affected)

Thompson, Bill D (London) bill_d_thompson at ml.com
Thu Nov 6 14:41:50 EST 2003


Hi,

I tried the below test on latest snapshot of this a.m.

I got the same results, which look correct to me...have you anything I can
reproduce my end ?

Bill

> -----Original Message-----
> From:	Thompson, Bill D (London) 
> Sent:	06 November 2003 09:12
> To:	'FreeTDS Development Group'
> Subject:	RE: [freetds] (-1 rows affected)
> 
> 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
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds



More information about the FreeTDS mailing list