sybperl-l Archive

From: Karsten Spakowski <spacki at pol dot de>
Subject: NUMBER of affected rows
Date: May 10 2001 11:26AM

Hi folks,

I work with the DBI and DBD Module on a Sybase Server 11.9.

After the execution of an select statement,  I will check the number of
affected row,
but I get always the -1.

my $sth = $dbh->prepare("Select name from patient
                                            where name = \"Anybody\"");
my $rc = $sth->execute();
print "$rc affected rows \n";

while (my @row = $sth->fetchrow_array()) {
    print "Row: @row \n";
}

Even if I have some affected data,
the variable $rc told me always the number of affected rows are unknown.

Does anybody  know what could be causing this problem?

Thanks in advance.
Karsten Spakowski