[mapguide-users] Select points problem

[Big Tom]

In Maestro, does this PK show up as the key column? If not have you set it?

- Jackie




Have you defined a primary key for that point table?

- Jackie



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:


ARE_COORDENADA is SDO_GEOMETRY type and ARE_CODARE is my PK





Table in Maestro


It's ok? How can I set PK in Maestro?

-- 
View this message in context: http://n2.nabble.com/Select-points-problem-tp2640686p2651634.html
Sent from the MapGuide Users mailing list archive at Nabble.com.