Ok, some updates. The database I was joining to was SQL Server 2000.
In the process of preparing the problem data package, I converted the relevant portions of the SQL Server database to MS Access, under the assumption of the original bug description (ie, the bug still occured despite different databases) However when I tested this with the MS Access database, the bug disappeared (?) So I went into further investigation into the SQL Server 2000 database. The problematic feature join was between a SDF file to a SQL Server 2000 view. Just as a hunch, I dumped the contents of the view into a table, and renamed the view and table so that the SDF was now joined to a table instead of a view. When I looked at the layer again, the bug once again disappeared! Which leaves me to the following conclusion... There is a table/view inconsistency in SQL Server 2000 with regards to feature joins. As a result, I'll most likely leave the original ticket closed, and open a new one instead. The only problem is the SQL Server database is 1GB (how could I package that?????) I can't convert it into a different database without invalidating the bug. I'll try and reproduce the problem with a smaller sample data to see if my theory holds any weight. - Jackie Jackie Ng wrote: > > Hi Jason, > > I'm in the process of preparing this new problem package, which I'll > attach to that ticket. > > - Jackie > > > JasonBirch wrote: >> >> Hi Jackie, >> >> I closed that under the assumption that it was a problem with the >> SHP->SDF translation in Studio. If you are seeing the problem under >> different circumstances, please re-open the ticket. If you have an >> additional package that you could create to show the problem with this >> new data, as well as detailed (so a robot could understand) steps to >> reproduce, then that would be good. >> >> Also, if you want to provide me with a link off-list to download the >> original SHP files, I'd be happy to run them through FME, test for >> invalid features, etc..., and give them back to you as SDF just in case >> there's a problem with Map as well. >> >> Jason >> >> ________________________________ >> >> From: Jackie Ng >> Subject: [mapguide-users] Major Feature Join Problems >> >> >> >> I wasn't fussed about the ticket being filed invalid, because I was able >> to >> workaround the problem by exporting straight to SDF, instead of exporting >> to >> SHP -> convert to SDF at the load procedure. >> >> >> >> >> _______________________________________________ >> mapguide-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> >> > > -- View this message in context: http://www.nabble.com/Major-Feature-Join-Problems-tf4716245s16610.html#a13482950 Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
