<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:tj_trevor.jones@yahoo.co.uk" title="tj_trevor.jones@yahoo.co.uk">tj_trevor.jones@yahoo.co.uk</a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Base Editing Create Query in Design View generates incorrect SQL"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133997">bug 133997</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>REOPENED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Base Editing Create Query in Design View generates incorrect SQL"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133997#c8">Comment # 8</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Base Editing Create Query in Design View generates incorrect SQL"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133997">bug 133997</a>
from <span class="vcard"><a class="email" href="mailto:tj_trevor.jones@yahoo.co.uk" title="tj_trevor.jones@yahoo.co.uk">tj_trevor.jones@yahoo.co.uk</a>
</span></b>
<pre>A big apology from me.
I tried to simplify my problem in order to post it here and in doing so changed
it.
What I was trying to do was -
SELECT "Table1".* FROM "Table1"
WHERE ( "Field1A" = :AskA OR :AskA IS NULL) AND ("Field1B" = :AskB OR :AskB IS
NULL)
What originally confused me was when you switch from design to SQL and then
back again the query is presented in a different form.
In fact (In release 6.4.4.2) it all works.
Sorry to have wasted you time.
A very embarrassed Trevor.</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>