[mapguide-users] Layer's selection Problem

[padmini godavarthi]

Hi,
Thanks for u r reply.
i  saw the link given by u.
but i didn't get it
can u explain the solution for this ?

Thanks and Regards,
Padmini.



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