I received this error whenever I update an int(3) type field.

Error: 438 public member close on type integer not found

This is my code

conn.ConnectionString = "server=localhost;user id=root;password=;database=test"
        SQL = "UPDATE testTable SET int = 1 WHERE Name= 'Bob'"

            Dim myData
            With myCommand
                .Connection = conn
                .CommandText = SQL


                myData = .ExecuteNonQuery()


            End With

        Catch ex As Exception
        End Try

If I remove line 17. myData.Close, the error disappears. I think that it is important to keep that line. Anyway around this?

How come I can't edit my own post?

Anyway, is myData.Close() really that important?

Can anyone tell me why I am getting the error with myData.Close()? And not get the error without it?