[fdo-users] SDF Provider : where clause problem and argument order !

[lunab54]

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

 

Rémy

 

 

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 !

 

Hi,

 

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 ?

 

Thanks

 

Rémy

 

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...
URL: <http://lists.osgeo.org/pipermail/fdo-users/attachments/20130110/467f6626/attachment.html>