[mapguide-users] Layer's selection Problem

[aniliht]

I'm also using a sql server 2008 and have 2 simple tables as follows:

Drawing
- DrawingID (PK, int, not null)
- DrawingName (varchar(50))

Point
- PointID (PK, int, not null)
- DrawingID (FK, int, not null)
- Name (varchar(50))
- Point (geography, not null)

There is one row in each table,  the geography instance is in SRID 4326 (WGS
84).  The item displays properly but I can't select it no matter what.

I'm using the windows install of Mapguide 2.0.2:
MgServerSetup-2.0.2.3011.exe.  It did not have the SQL Server Spatial
provider bundled.  So I installed the fdosqlserverspatial-3.3.0_win32.tar.gz
which is SQL Server Spatial BETA 1.  I chose this because the dll version of
the bundled FDO.dll that the MgServerSetup installed was 3.3.0.3901.

Do you know if the BETA 1 version of the SQL Server Spatial provider doesn't
support selection on layers?

What version of MapGuide, FDO, SQL Server Spatial Provider releases work to
be able to select points on a SQL layer?  

Is it ok to install the latest version of FDO (which is 3.3.2) into the
C:\Program Files\MapGuideOpenSource2.0\Server\Bin\FDO directory,
overwritting the contents that the MgServerSetup placed?  

The release notes for MG 2.0.2 says: "MGOS 2.0.2 is compatible with FDO
3.3.1 but the version packaged with the installers is actually a newer
version."  But the version of FDO in the Bin directory appears to be
3.3.0.3901.

Thanks for any clues you can provide.



miansi wrote:
> 
> I have exactly the same behaviour for SQL 2008.
> 
> I do not know if this is applicable for Oracle, but for SQL
> 1. You have to have Primary Key (clustered) on the table you want to show
> on the layer
> 2. PK has to be int
> 3. You have to create spatial index on the spatial column
> 4. As soon as you will try to add JOINS to your database view (if you
> trying to show layer off View) - you will lose selection functionality. I
> am fighting with this one for week already.
> 
> 
> Hope that will help
> 
> 
> padmini godavarthi wrote:
>> 
>> Hi, 
>> iam using mapguide opensource 2.0 (with .net 2.0 +IIS 5.1) 
>> 
>> I have created a package using Oracle "OSGEO FDO provider for Oracle" 
>> and Mapguide Maestro. 
>> but while seeing the map by"Show in browser" the layers are does not
>> selecting on map and the properties is not displaying even after i
>> checked the option "Features on layer are selectable" in the map
>> resource. 
>> 
>> Is anything i did wrong? 
>> 
>> Can u plz tell me the solution? 
>> 
>> 
>> Thanks and Regards, 
>> Padmini. 
>> 
>> 
> 
> 

-- 
View this message in context: http://n2.nabble.com/Layer%27s-selection-Problem-tp2352146p2452746.html
Sent from the MapGuide Users mailing list archive at Nabble.com.