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:[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-tp2352146p2363251.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
