I'm working on a database project that uses MySQL and VB6. The program has lots of SQL statement for processing data and neither one object is bound to the database, everything is fetch and save manually.

One thing I notice about the system is, whenever I pass a query, the computer where the program is becomes idle, it waits for the server to finish the processing.
What I wanted to do is something like this... if I issue

dbConnection.execute sqlStatement

I like the workstation not to become idle or not to wait especially if the query is an "Update" or "Insert" query.

Is this possible ?

(I saw this idea in MySQL Query Browser and MySQL Command Center. Whenever you click on the execute button, the workstation seems like just to "pass" the query to the server then it will just fetch the data if it is ready. you can do anything on the system while you wait for your data to come.)

Thank you very much in advance