Skip to Content.
Sympa Menu

freetds - RE: [freetds] (-1 rows affected)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] (-1 rows affected)
  • Date: Thu, 6 Nov 2003 14:41:50 -0000

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





Archive powered by MHonArc 2.6.24.

Top of Page