[mapguide-users] MS SQL and SDF Join Problem

[Rock Beans]

I have seen this issue with the SQL Spatial FDO provider as well. The
join options don't work everything is always one-to-one which means
only objects with data in the joined table show up on map, not good. I
also have seen this on Oracle, this seems to be an ongoing FDO issue
within MapGuide. Sorry I have no solutions or work around other than
exporting your sdf/shp/etc with all the external data which means you
don;t need the join anymore. This is not dynamic though, I realize
this but ti works. It brings more data batch processing to the table
which most clients do not like.

The Rock

On Thu, Sep 11, 2008 at 10:18 PM, anakando <anakando at yahoo.com> wrote:
>
> Hi guys..
> I faced a very big problem (i guess) since i cannot overcome this problem
> for almost 2 weeks! Let me simplify my problem. I have successful makes a
> join between my sdf file and MS SQL, but the problem is,after joining,it
> only show only first row data form MS SQL. The type of join is inner join,
> and relationship with secondary records is one-to-one. But when i change
> type of join to left outer join, it will show all the data from MS SQL but
> with a 'null' value! I have do some research about this problem but i can't
> find something useful for me. If somebody out there already experienced and
> successful solved the problem, please let me know. TQ
> --
> View this message in context: http://www.nabble.com/MS-SQL-and-SDF-Join-Problem-tp19448719p19448719.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>