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:[email protected]] 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.
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
