[mapguide-users] Mapguide and ODBC

[Gord McKenzie]

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: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Hans Milling
Sent: Wednesday, April 22, 2015 3:36 AM
To: mapguide-users at lists.osgeo.org
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
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users