Unanswered: Visual Basic not waiting for MySQL to finish
It seems my VB app is impatient insofaras it won't wait for MySQL to return a recordset result from a query. I have confirmed this by executing the same query directly in MySQL (using MySQL Control Center aka MySQLCC) and getting a result of several rows.
Is there any way to force VB to wait for MySQL to finish?
And here is how I execute the query (strSQL is devised in another subroutine and has been proven valid):
.ActiveConnection = mconCM
.CommandTimeout = 30
.CommandType = adCmdText
.CommandText = strSQL
Set rstRecordset = cmdSQL.Execute()