I am encountering some strange behavior with MySQL++.

MySQL++ 1.7.1 Using VC++ 6.0.

Periodically I get a "bad query" exception on a query. The exception doesn't seem to return an error message, and the query itself can be successfully run on the same database. At present, my only explanation is that it is a locking problem and that the query is failing due to the table being locked by another query and the problem query returns empty instead of waiting for the table lock to be released.

Here are a couple of example queries: "select * from faxlist where faxlistID = 279" "select id_value from id_sequences where id_name = 'reportid' for update"

Is this possible? It shouldn't be according to the MySQL docs, but I can't think of another explanation at this point.

Could there be something else that is causing this? The lack of an error message gives me some concern.

Thanks in advance. I have subscribe to the list (I think) and checked the archives, but if you could also send your answers directly to me I'd appreciate it.