I get the same problem here. <br><br>It seems to me that the SQL generator goes a bit too far in wrapping everything in parenthesis ?<br><br>Unfortunately it seems that the SDE provider is currently broken.<br><br><br>-- Oyvind<br>
<br><br><div class="gmail_quote">On Fri, Oct 1, 2010 at 10:27 AM, maland <span dir="ltr"><<a href="mailto:hma@powel.com">hma@powel.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
I've been able to find the SQL generated by the ArcSDEFilterToSql class, and<br>
there is obviously a problem with the parantheses matching. Example of SQL<br>
generated:<br>
<br>
SELECT XROW, YROW FROM EXAMPLE_POINTS WHERE YROW = 0 AND ( ( ( (XROW) =<br>
(0) ( OR ( (XROW) = (1) ) ) )<br>
<br>
Hopefully the authors of the FDO ArcSDE provider can have a look at this?<br>
<br>
<br>
Regards<br>
Henning<br>
<font color="#888888">--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/FDO-3-5-ArcSDE-Provider-Oracle-ORA-00920-tp5587468p5590547.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/FDO-3-5-ArcSDE-Provider-Oracle-ORA-00920-tp5587468p5590547.html</a><br>
</font><div><div></div><div class="h5">Sent from the FDO Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
fdo-users mailing list<br>
<a href="mailto:fdo-users@lists.osgeo.org">fdo-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/fdo-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-users</a><br>
</div></div></blockquote></div><br>