<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - SQL commands do not work in MACRO Basic, but does work through Tools/SQL with Firebird embedded"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131449">131449</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>SQL commands do not work in MACRO Basic, but does work through Tools/SQL with Firebird embedded
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.2.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>putmannFB@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>