Description:
DROP Table or Delete From (SQL Commands) do not work properly from Macro BASIC within a menu button because the dropped table still exists in the database after pressing button. However, when the menu button to DROP Table is pressed a 2nd time an error message appears stating the table does not exist.
The table does exist

example
Sub UpdateWinners
REM INSERT RECORDS INTO DATABASE TABLE
Dim Context As Object
Dim DB As Object
Dim Conn As Object
Dim Stmt As Object
rem Dim Result
Dim strSQL As String
Context=CreateUnoService("com.sun.star.sdb.DatabaseContext") '< get  the database context
DB=Context.getByName("Baseball Stats") '<- change database name
Conn=DB.getConnection("","") '<-  default blank
Stmt=Conn.createStatement()

strSQL = " DELETE From ""tblWorldSeriesWinners"" "
Stmt.executeUpdate(strSQL) '<- delete the Winners table


Actual Results:
Nothing/No Error

Expected Results:
Dropped table


Reproducible: Always


User Profile Reset: No



Additional Info:
Dropped table