How to clear error state from connection?

[dilbir]

Hi,
At start of my application I create one connection object then use
that connection for retrieving ,inserting ,upedating and deleting of
data. While closing the application i close the connection.
My problem is when there occurs an error in one step, i can't
proceed next and ignore that error. e.g if i get error while inserting
data, i can't correct the error and insert again because I always get
the old error message even for new query...

Does my logic and approach is good? Are should I get new connection
for each query?

My Environment. MySQL ++ (MySQL++ 1.7.1 for VS by
lazyfox),Windows/Linux OS clien/server.

Regards.

Dilbir.