sybperl-l Archive

From: sy50027 at milton dot sbi dot com (Simon Yaminian)
Subject: Re: Obtaining rowcount when updating
Date: Sep 24 1998 10:02PM

> From owner-SYBPERL-L@listproc.net Thu Sep 24 17:49:15 1998
> From: Michael Peppler 
> Mime-Version: 1.0
> Content-Transfer-Encoding: 7bit
> Date: Thu, 24 Sep 1998 14:10:08 -0700 (PDT)
> To: SybPerl Discussion List 
> Subject: Re: Obtaining rowcount when updating
> X-Listprocessor-Version: 8.2.07 -- ListProc(tm) by CREN
> 
> Simon Yaminian writes:
>  > 
>  > 
>  >    I tried getting the number of rows using $dbh->DBCOUNT after an update
>  > and it returned 0. Even with the insert, it returned 0.
> 
> Sorry.
> 
> It should be DBCOUNT, not DBROWS.
> 
> DBROWS is 0 if there are no rows returned by the SQL command, and 1
> otherwise.
> 
> BTW this is documented in the Sybase manuals that are available on
> line at http://sybooks.sybase.com. Please make an effort to look
> things up - it will give you a better understanding of how DBlibrary
> works.
> 
> Michael
> -- 
> Michael Peppler         -||-  Data Migrations Inc.
> mpeppler@mbay.net       -||-  http://www.mbay.net/~mpeppler
> Int. Sybase User Group  -||-  http://www.isug.com
> 
> 
Thanks for the reply,

   If you notice in my message, I did use DBCOUNT (and not DBROWS - I looked
up both before trying them) and it still produced 0 as the rowcount.

Regards
Simon Yaminian