[fdo-users] Re: FDO 3.5 ArcSDE Provider Oracle ORA-00920

[Oyvind Idland]

I get the same problem here.

It seems to me that the SQL generator goes a bit too far in wrapping
everything in parenthesis ?

Unfortunately it seems that the SDE provider is currently broken.


-- Oyvind


On Fri, Oct 1, 2010 at 10:27 AM, maland <hma at powel.com> wrote:

>
> I've been able to find the SQL generated by the ArcSDEFilterToSql class,
> and
> there is obviously a problem with the parantheses matching. Example of SQL
> generated:
>
> SELECT  XROW, YROW FROM EXAMPLE_POINTS WHERE YROW = 0  AND  ( ( ( (XROW)  =
> (0)  ( OR  ( (XROW)  =  (1) ) ) )
>
> Hopefully the authors of the FDO ArcSDE provider can have a look at this?
>
>
> Regards
> Henning
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/FDO-3-5-ArcSDE-Provider-Oracle-ORA-00920-tp5587468p5590547.html
> Sent from the FDO Users mailing list archive at Nabble.com.
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20101004/cdb8fa84/attachment.html