[mapguide-users] Layer's selection Problem

[padmini godavarthi]

Hi,
Thanks for u r reply.
But in my table i have   OBJECTID   NOT NULL NUMBER(38) .
1) i think i have OBJECTID as Primary key.
2) and i have created spatial index for geometry column.

But it didn't selecting
Has any solution for this?

Thanks,
Padmini.


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-tp2352146p2357923.html
Sent from the MapGuide Users mailing list archive at Nabble.com.