Hi, can anyone help me to achieve layer selection in oracle package. iam unable to find the solution ??????
Regards, Padmini. aniliht wrote: > > 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-tp2352146p2473167.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
