PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: David C Worenklein <dcw at gcm dot com>
Subject: Re: Obtaining rowcount when updating
Date: Sep 29 1998 3:07PM

>>>>> "Michael" == Michael Peppler  writes:
    Michael>  Simon Yaminian writes:
    Michael>  Perfectly normal.
    Michael> 
    Michael> The first dbresults() is for the actual insert, and on an
    Michael> insert there are no rows, so dbnextrow() returns an empty
    Michael> array.  The second call to dbresults() will return
    Michael> NO_MORE_RESULTS (if there was only one insert statement).
    Michael> 
    Michael> YOu get the number of rows affected with DBROWS.

Watch out for insert triggers - they can trigger dbresults.