Trying to drop a table when deleting a user account. Can someone point me to problem?
dim s as string
s= “Farmacia”+selectedrecord+“Prescriptions”
Dim sql As String
sql = “DROP TABLE “+s+”;”
If IsConnected Then
mDB.SQLExecute(sql)
If mDB.Error Then
textarea1.text="DB Error: " + mDB.ErrorMessage
Return
End If
StatusLabel.Text = "Table deleted!"
Else
MsgBox(“Connect to the database first.”)
End If