Are you using King.Oracle provider ? Which version of 9i are you using ? Not easy for me to read from email bellow :). You do have primary key defined ? If you are using King.Oracle you should check with Fdo2Fdo to confirm that FDO class created from that oracle table has identity defined.
Also, one think I can remember happened to me recently for me is wrong precision number set for dimensions in sdo_metadata table. That too you can check that with Fdo2Fdo. Haris -----Original Message----- From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Big Tom Sent: Monday, April 27, 2009 10:19 PM To: mapguide-users@lists.osgeo.org Subject: Re: [mapguide-users] Select points problem Big Tom wrote: > > > > Big Tom wrote: >> >> >> >> Jackie Ng wrote: >>> >>> In Maestro, does this PK show up as the key column? If not have you set >>> it? >>> >>> - Jackie >>> >>> >>> Big Tom wrote: >>>> >>>> >>>> Big Tom wrote: >>>>> >>>>> >>>>> Jackie Ng wrote: >>>>>> >>>>>> Have you defined a primary key for that point table? >>>>>> >>>>>> - Jackie >>>>>> >>>>>> >>>>>> Big Tom wrote: >>>>>>> >>>>>>> >>>>>>> Jamo wrote: >>>>>>>> >>>>>>>> Check that the datasource has a X, Y and Z value even if it only >>>>>>>> requires an X, Y just assign one of the X, Y columns to the Z and >>>>>>>> retry, had this problem a while ago and this seemed to fix it. >>>>>>>> >>>>>>>> Good luck >>>>>>>> >>>>>>> >>>>>>> I try this: >>>>>>> MDSYS.SDO_GEOMETRY( >>>>>>> 2001, >>>>>>> NULL, >>>>>>> MDSYS.SDO_POINT_TYPE(ARE_LONGITUDE, ARE_LATITUDE, >>>>>>> ARE_LATITUDE), >>>>>>> NULL, >>>>>>> NULL) >>>>>>> >>>>>>> and this: >>>>>>> MDSYS.SDO_GEOMETRY( >>>>>>> 2001, >>>>>>> NULL, >>>>>>> MDSYS.SDO_POINT_TYPE(ARE_LONGITUDE, ARE_LATITUDE, >>>>>>> ARE_LONGITUDE), >>>>>>> NULL, >>>>>>> NULL) >>>>>>> >>>>>>> >>>>>>> but nothing happens:-(( >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> Yeap, the table has a PK. >>>>> >>>>> I'm using Oracle 9i >>>>> >>>>> >>>> >>>> >>>> My Table: >>>> http://n2.nabble.com/file/n2650913/screenhunter01200904171.jpg >>>> >>>> ARE_COORDENADA is SDO_GEOMETRY type and ARE_CODARE is my PK >>>> >>>> >>> >>> >> >> Table in Maestro >> http://n2.nabble.com/file/n2651634/screenhunter01200904171.jpg >> >> It's ok? How can I set PK in Maestro? >> >> > > Anyone? > > Hey guys, anyone can help me? Please... :-(( -- View this message in context: http://n2.nabble.com/Select-points-problem-tp2640686p2728310.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users