[mapguide-users] Re: MGOS v2.2 Beta ! and SQL 2008. Again...

[miansi]

Thank you Jackie,

I do not care about spatial preview that much. I just want SQL FDO to work
and looks like it is not cooperating.
For example if I am trying to set map extents to the layer extents I see
following error:

http://osgeo-org.1803224.n2.nabble.com/file/n5206134/RoadSQL.png 

I am using SQL Views with join to show features on the layer:

CREATE VIEW [geo].[vw_Road_Roadway] 
WITH SCHEMABINDING 
AS 
		   SELECT 
				  [base].[Id] 
				, [CategoryId] 
				, [SpatialStatusId] 
				, [LifecycleStatusId] 
				, [MaterialId] 
				, [AddressId] 
				, [DisplayId] 
				, [SpatialId] 
				, [ReportingId] 
				, Year([StatusDate]) StatusYear 
				, convert(varchar,[StatusDate],101) StatusDate 
				, [LocationDescription] 
				, [Geo] 
				, [Length] 
			 FROM [dbo].[Asset] [base] 
	   INNER JOIN [dbo].[Road_Roadway] [asset] ON [base].[Id] = [asset].[Id] 
			WHERE [base].[Geo] IS NOT NULL 
			  AND [base].[SpatialId] IS NOT NULL 

GO

but binding layer to the table instead of view not helping.

Basically - I am not able to retrieve spatial data from MS SQL and present
it on the map
-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/MGOS-v2-2-Beta-and-SQL-2008-Again-tp5197257p5206134.html
Sent from the MapGuide Users mailing list archive at Nabble.com.