Re: [mapguide-users] Mapguide and ODBC

2015-04-27 Thread 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 M

Re: [mapguide-users] Mapguide and ODBC

2015-04-27 Thread Gord McKenzie
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

Re: [mapguide-users] Mapguide and ODBC

2015-04-27 Thread Gord McKenzie
I will work to get you a sample. Not sure what my best method is for selecting a subset of records as I have not identified a good pattern in the data but I will work to get a subset that has some that match and some that don't. AutoCAD Map 2012, 2013 and 2015 all work as expected. I have tried