[fdo-users] SDF Provider : where clause problem and argument order !
lunab54 at free.fr
Thu Jan 10 06:01:59 PST 2013
For information, my issue is solved.
The SDF Field « RESEAU » is in VARCHAR so if I set “RESEAU <> 4” MapGuide failed to display feature and unstable.
I translate the field RESEAU in NUMBER and now it’s Ok.
It’s specific to SDF Provider because with King Oracle the issue doesn’t exist. Fly Conversion type is Ok not with SDF Provider
De : fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] De la part de Rémy Gourrat
Envoyé : lundi 7 janvier 2013 10:21
À : fdo-users at lists.osgeo.org
Objet : [fdo-users] SDF Provider : where clause problem and argument order !
I have a big issue with where clause with SDF Provider on :
1. MapGuide 2.2
2. Mg-desktop 2.4
Same Data, layers and Map
If in my point layer I set a where clause like “RESEAU NULL OR RESEAU <> 4”, it’s running fine. Every feature is displaying : Null and <> 4
But if I set :
“RESEAU <> 4 OR RESEAU NULL” only not null features are displaying (<> 4) !
Could you reproduce, My syntax is bad ?
AG-Carto - Bayonne
View this message in context: SDF <http://osgeo-org.1560.n6.nabble.com/SDF-Provider-where-clause-problem-and-argument-order-tp5025901.html> Provider : where clause problem and argument order !
Sent from the FDO Users <http://osgeo-org.1560.n6.nabble.com/FDO-Users-f3898664.html> mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the fdo-users