<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 - Issue with query parameters in 6.1"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118984">118984</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Issue with query parameters in 6.1
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.0.0.beta1+
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</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>gerhard.schaber@gmx.at
</td>
</tr></table>
<p>
<div>
<pre>When I try to open a query with parameters, I get the following error:
"Die Dateninhalte konnten nicht geladen werden.", which means something like
"data could not be loaded".
"firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -206
*Column unknown
*BIS_DATUM
*At line 1, column 9406
caused by
'isc_dsql_prepare'"
The query is something like "SELECT * FROM "query1" WHERE "dt" >= :FROM_DATE
AND "dt" <= :TO_DATE". There is even the popup dialog that allows me to enter
dates for the parameters, but then the error is shown.
Happens with 6.1.0rc2 and 6.1.0.beta1. Does not happen with 6.0.5.
I haven't been able to reproduce this with a simple database document, yet. I
cannot send the original one. I use a cascade of queries. I am still trying to
simplify this.</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>