Thread: Retrieve Number of rows to be DELETEd

I'm using ECPG and embedded SQL.  In the C interface, there is a
PQcmdTuples() command which returns the number of rows affected by an SQL
statement.  In embedded SQL, other than doing a SELECT count(*) first, is
there a way to get the number of rows that may be/were affected by a
delete or update?

Thanks,
--
Matthew Vanecek
perl -e 'print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);'
********************************************************************************
For 93 million miles, there is nothing between the sun and my shadow except me.
I'm always getting in the way of something...

Take a look in: sqlca.sqlerrd[2]

Lee.

"\"Matthew V.\" writes:
 > I'm using ECPG and embedded SQL.  In the C interface, there is a
 > PQcmdTuples() command which returns the number of rows affected by an SQL
 > statement.  In embedded SQL, other than doing a SELECT count(*) first, is
 > there a way to get the number of rows that may be/were affected by a
 > delete or update?

Take a look in: sqlca.sqlerrd[2]

(and if you're going to post on a public list, use a real email
address)

Lee.

"\"Matthew V.\" writes:
 > I'm using ECPG and embedded SQL.  In the C interface, there is a
 > PQcmdTuples() command which returns the number of rows affected by an SQL
 > statement.  In embedded SQL, other than doing a SELECT count(*) first, is
 > there a way to get the number of rows that may be/were affected by a
 > delete or update?