02-24-2020 11:58 AM
I have the following feature defined from the following query:
Select Geometry_SPA.STGeometryType() AS GeometryType ,CASE WHEN GEOMETRY_SPA.STGeometryType() = 'Polygon' THEN GEOMETRY_SPA.STCentroid() ELSE -- points GEOMETRY_SPA.STStartPoint() END AS GEOMETRY_SPA ,CASE WHEN GEOMETRY_SPA.STGeometryType() = 'Polygon' THEN [dbo].[SqlGeometry2Binary] ( GEOMETRY_SPA.STCentroid()) ELSE -- points [dbo].[SqlGeometry2Binary] ( GEOMETRY_SPA.STStartPoint() ) END AS [GEOMETRY] FROM WHeritageCulture.dbo.Item
SqlGeometry2Binary converts but Geomedia SmartClient won't read it.
It works fine on Geomedia.
Any suggestion on how can make GMSC read my Geometry?
Solved! Go to Solution.
02-24-2020 12:57 PM
As the SqlGeometry2Binary will convert into Native binary and not into Geomedia binary. So, if GMSC finds a Geometry column already filled it will not read but if you give a NULL Column will do..
For this work you will need to add a Fake column: Geometry(VarBinary) as NULL.