[mapguide-users] Select points problem

[Big Tom]

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?

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