[mapguide-users] Problem quering joined tables

[Mauricio Villablanca]

My question is for Mapguide Enterprise but someone might have a solution
here.

I have a layer that uses a join of an ODBC connection to an Access database
and an Oracle connection (Autodesk provider). The ODBC stores multiple rows
for each Oracle feature so I'm using a one-to-many left join.

I'm using the attribute ProjectId from both tables to do the join.

The features display in the map just fine but I am having a problem querying
a specific feature by running an Invoke URL command in Mapguide Studio.

I wrote a script based on the Generic Tasks query script that queries
features by attribute only and my queries run ok except for one feature. 

I traced the problem to this line:



For a reason I don't understand the reader is empty so when I call 


nothing happens returning empty results. It's obvious that the feature is
there since I can see it in the map and I'm invoking an URL from it. Also
that attribute is correctly passed to the invoked script that runs the
query.

If I use the filter "ProjectId = '09-802'" in the layer, the features
display but I can't query them. Does anybody an idea why? Again this happens
only with one feature, all other queries run fine. I tried switching to an
inner join with no effect.



--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Problem-quering-joined-tables-tp6839081p6839081.html
Sent from the MapGuide Users mailing list archive at Nabble.com.