[mapguide-users] Select points problem

[Big Tom]

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.