Hello,

I'm working on an application in C++ using a MySQL 5 database with ADO
connection.

I send an UPDATE query and I'd like to know how many rows where
affected by the command. I heard about a mysql_affected_rows() function
for this purpose, but when I try to use it, it is not recognized by my
C++ compiler.

Is there a way to know the affected rows number by accessing some
information from the ADO objects, like :

ado20::_RecordsetPtr pRec = NULL;
ado20::_ConnectionPtr pCon = NULL;

Thankk you for your help.

Yo wrote:

If the correct header file is is not #include-d, the compiler might get
irritable about it's or it's parameters definition, but it can not
recognise it, since you have implicitly declared it..

If you don't link with the mysql C API library, the linker will get
irritable of course.

The Natural Philosopher a utilisé son clavier pour écrire :
Thanks. So is there another way (rather than linking with mysql C API
and using mysql_affected-rows()) to know how many rows were affected by
my query ?

On Mon, 25 Oct 2010 16:19:18 +0200, Yo wrote:
If you're using ADO to managed the connection and execute the query,
you'll have to use ADO to get the number of affected rows. One always
has to stay within the framework...

http://dev.mysql.com/doc/refman/5.0/...-microsoft-ado

--
"Doesn't everybody?" is a question that never expects an answer of "No."

Yo wrote:
you didn't tell me any more than the last post.

If you don't have the mysql C++ and/or C API library you have no way to
access mysql database, so basically no sql access will work.

Peter H. Coffin wrote:

I missed the ADO bit. All becomes clear.