I am inserting rows into a MySQL DB from VB6 using ADO and was wondering if the .Execute method returns a Return Code after execution. Here are my code snippets:
Dim MySQLConn As New ADODB.Connection
wTestName = txtTestName.Text
InsertString = "Insert into ProductCert.tests (test_name) value ('" & wTestName & "')"
Can I code the .Execute as such:
rc = MySQLConn.Execute(InsertString)
and expect a RC to be returned? If so, what should the data type of rc be?