Oracle View with Join

[Anonymous]

Hello,

i have aproblem with a view

i have a alpha Table T1 and a geomtric table T2

i have a view V_T1_T2 like this :

SELECT T1.ID,T1.AFFECTATION,T2.GEOMETRY
FROM T1 LEFT JOIN T2 ON T1.ID = T2.ID

when i want to see this layer in MapGuide i have an error

but if i do :

SELECT T1.ID,T1.AFFECTATION,T2.GEOMETRY
FROM T1 RIGHT JOIN T2 ON T1.ID = T2.ID

it's Ok (with JOIN or RIGHT JOIN)

i'm agree that MpaGuide can't draw object with a null Geometry but it must be able to draw the others, isn'it ?

is there a patch for this ? or a good issue ?

Thanks

Lunab

[Anonymous]

Lunab,
I think you almost hit on the precise problem in your comment that "MapGuide can't draw object with a null Geometry..."

That is indeed the problem. There will always be a problem if any of the features have null geometry.

One solution, if you "need" the left join to allow for a null GEOMETRY column in your view definition, is to exclude these rows when you define the layer in MapGuide Author.

In Author, within the layer definition, populate the WHERE clause box with GEOMETRY IS NOT NULL

That way, although there are null geometries in your view definition, Author will ignore these records in the layer definition.

Hope this helps,
Jason Schwartz
SNWA
Las Vegas NV 89119
www.snwa.com

[Anonymous]

All,

We often run into issues like this and find that a good understanding of the
underlying data usually solves - or gets close to solving - such problems.

For our internal use (and now free on the web) IME have developed a small
applet that will assess and report on data in any Oracle schema... have a
look at http://www.ime.co.uk/ime/content/apps/osc.jsp

Crispin
IME.co.uk


wrote in message news:5328639@discussion.autodesk.com...
Hello,

i have aproblem with a view

i have a alpha Table T1 and a geomtric table T2

i have a view V_T1_T2 like this :

SELECT T1.ID,T1.AFFECTATION,T2.GEOMETRY
FROM T1 LEFT JOIN T2 ON T1.ID = T2.ID

when i want to see this layer in MapGuide i have an error

but if i do :

SELECT T1.ID,T1.AFFECTATION,T2.GEOMETRY
FROM T1 RIGHT JOIN T2 ON T1.ID = T2.ID

it's Ok (with JOIN or RIGHT JOIN)

i'm agree that MpaGuide can't draw object with a null Geometry but it must
be able to draw the others, isn'it ?

is there a patch for this ? or a good issue ?

Thanks

Lunab