Thanks for the answer. Unfortunately this is a textual ID provided by the government and it is applied to the geometry objects in the sdf file at a different time then when the database record is created. This application has been running for some time in MS Access and works fine there. I am trying to upgrade to newer Mapguide and to move to SQL Server instead of Access. I can actually create the join between the SDF and SQL Server in AutoCAD Map and it works fine there as well.
I have had many issues with ODBC and Mapguide, similar to those documented by others on this list. It seems that ODBC and Mapguide connectivity is just a bit of a fussy thing. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hans Milling Sent: Wednesday, April 22, 2015 3:36 AM To: [email protected] Subject: Re: [mapguide-users] Mapguide and ODBC If your string column is e.g. "typeofhouse" and it is either: villa cityhouse appartment school government create a new int column named typeid and set an id to each type. update houses set typeid=1 where typeofhouse='villa' You then have the typeid column updated as this: villa=1 cityhouse = 2 appartment = 3 school = 4 government = 5 Add the same typeid column in the other table and update this the same way. Tjen you can join using the int column instead of the text column. Best regards Hans Milling... -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Mapguide-and-ODBC-tp5202365p5202427.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
