We are currently using shapefiles with joins with good results.
2 issues affect whether features display or not.
1 is geometry related - repair geometry in ArcMap
2 is the join field. If the Shapefile ID is text, so must the SQL table.
If there are null IDs in the shapefile, the join may fail.
Especially the performance makes the joins useless.
--
View this message in context:
http://n2.nabble.com/Shape-Files-and-Joins-tp4611381p4621196.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
___
mapguide-users mailing list
mapg
This may be a long shot, but can the randomly disappearing / reappearing
features be related to a corrupt spatial index file (.IDX) and not related
to the join at all?
Give this a try:
http://n2.nabble.com/Points-Disappearing-with-External-SHP-Connection-td4210614.html#a4211892
Good luck,
Denis
