From: Warren Young Date: August 20 2010 4:25am Subject: Re: execute() and store() discrepancy List-Archive: http://lists.mysql.com/plusplus/9023 Message-Id: MIME-Version: 1.0 (Apple Message framework v1081) Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable On Aug 19, 2010, at 9:42 PM, asokodesuka wrote: > Le 20/08/2010 05:31, Warren Young a =E9crit : >> execute() is for queries that do not return data per se. >=20 > And "this object also contains things like the number of rows that > the query affected" >=20 > So why res.rows() is wrong ? StoreQueryResult provides the num_rows() member function instead. > Maybe using a SELECT with execute() should return an error ? That would be something the underlying C API library would have to do, = or more likely the MySQL database server. It doesn't, so MySQL++ = doesn't. The only robust way for MySQL++ to do this itself would be for = it to contain a SQL parser, which just ain't gonna happen.