[mapguide-users] Layer's selection Problem

[miansi]

I tell you what I know J

 

Here is link to other post I made - check there for possible solutions:

 

http://n2.nabble.com/SQL-2008.-View-with-JOINS.-Not-able-to-select-featu
res-on-the-layer.-td2356197.html#a2356967

 

 

Hope that help

 

From: padmini godavarthi (via Nabble)
[mailto:ml-user+75460-387575619 at n2.nabble.com] 
Sent: Friday, February 20, 2009 2:34 AM
To: Sinelnikov, Andrei
Subject: Re: [mapguide-users] Layer's selection Problem

 

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. 


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. 





________________________________

This email is a reply to your post @
http://n2.nabble.com/Layer%27s-selection-Problem-tp2352146p2357923.html
You can reply by email or by visting the link above.

 



----Notice Regarding Confidentiality----
This email, including any and all attachments, (this "Email") is intended only for the party to whom it is addressed and may contain information that is confidential or privileged.  Sierra Systems Group Inc. and its affiliates accept no responsibility for any loss or damage suffered by any person resulting from any unauthorized use of or reliance upon this Email.  If you are not the intended recipient, you are hereby notified that any dissemination, copying or other use of this Email is prohibited.  Please notify us of the error in communication by return email and destroy all copies of this Email.  Thank you.

-- 
View this message in context: http://n2.nabble.com/Layer%27s-selection-Problem-tp2352146p2359904.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20090220/1d173273/attachment.html