From: Date: October 25 2007 3:16pm
Subject: Re: Expose errnum() in query -- BadQuery w/Errnum patch part 3
List-Archive: http://lists.mysql.com/plusplus/7127
Message-Id: <47209719.4030208@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Jim Wallace wrote:
> +	/// If you want the string *and* number you must 
> +	/// call errnum() before calling error() since error() clears

I tried to replicate that by causing an error in one of the examples, 
then calling Connection::errnum(), then error(), then errnum() again, 
and it shows the same number both times.

I think this is just leftover confusion from your initial problem 
diagnosis process.  It's not mysql_error() clearing the error number, 
it's the second error caused by the transaction failure.