[mapguide-users] Mapguide and ODBC

[Martin Morrison]

Can you change your query to 

UC(string1) == UC(string2)

*NOTE* the syntax may not be perfect, but you should be able to get my drift...

Martin Morrison
Application Engineer
Engineering Design Systems, Inc.
3780 Peters Creek Rd Ext SW
Roanoke, VA  24018
540.345.1410
gis.edsi.com

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Gord McKenzie
Sent: Monday, April 27, 2015 5:29 PM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] Mapguide and ODBC

Here is the scoop.

When the SQL Database has a string like 'xxx123' and the sdf has a string like 'XXX123' then the records don't match and that is the substance of the problem.  In AutoCAD Map, each id that is mismatched by case is still missing it's joined attributes.  However record matching continues with just the few case based mismatches.  When Mapguide does this, it hits the first mismatch and nothing else is matched after that.

In SQL Server, by default it has no trouble joining on xxx and XXX.

Gordon McKenzie
GIS Coordinator

T: 403.269.8887 / 1.800.478.6162 
E: Gord.Mckenzie at canam.com    canam.com 
900, 340 - 12th Avenue SW Calgary, AB T2R 1L5


-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Jackie Ng
Sent: Sunday, April 26, 2015 8:56 PM
To: mapguide-users at lists.osgeo.org
Subject: Re: [mapguide-users] Mapguide and ODBC

I'm afraid at this point, we'll need a small reproducible sample of this problematic SDF/SQL Server join in order to look at this issue any further.
Something that is 50-100 rows on either side with the sensitive information (except for the joining keys) sanitized/replaced should be sufficient.

IIRC MapGuide and AutoCAD Map share the same Feature Join engine. I'd be interested to know if this SDF <-> SQL Server join looks the same in AutoCAD Map 2013 or newer should you have access to such a version.

- Jackie



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Mapguide-and-ODBC-tp5202365p5203003.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users