I have checked this and it is bug in provider.<div><br><div>Bug appears if you define columns to be returned from select command and you do not select geometry column and you use spatial condition in filter.</div><div>In that case geometry which is to be used for spatial condition will have NULL for SRID , which will not work for Oracle tables which have SRID set.<br>
<div>With current version of provider workaround would be to beside columns you want to return in reader, you always add geometry column if you are using spatial condition in filter.</div><div><br></div><div>I already fixed this, need to write test before releasing it.</div>
<div><br></div><div>Haris</div><div><br><div class="gmail_quote">On Fri, Mar 5, 2010 at 5:11 PM, Crispin_at_1Spatial <span dir="ltr"><<a href="mailto:crispin.hoult@1spatial.com">crispin.hoult@1spatial.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><br>
Hi,<br>
<br>
I find this behaviour too - I have to code in an "unoptimisation" when the<br>
provide name is KingOracle which as you describe returns all columns (but<br>
does work!)<br>
<font color="#888888">--<br>
View this message in context: <a href="http://n2.nabble.com/King-Oracle-0-8-14-and-SetFilter-in-Mapguide-2-1-tp4681271p4681727.html" target="_blank">http://n2.nabble.com/King-Oracle-0-8-14-and-SetFilter-in-Mapguide-2-1-tp4681271p4681727.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></div></div></div>