These "bugs" are problems we've had. They haven't been certified as problems by Autodesk. Some of these may be "working as designed", but they are bugs to us.
The best workaround we've found is to append a non-breaking space character as the first character to be returned by the select statement, by appending a leading chr(160) as shown in this example:
select chr(160) + parcel + ' ',lat,lon,lat,lon from landbase
where parcel like trim(ucase('%s%%')) order by parcel
chr(160) is appropriate for DBF queries. SQL Server queries should use char(160) as the SQL Server function name is different.
Experimenting and testing shows that zoom gotos fail when the contents of the zoom goto's SELECT statement first returned field in any of the returned records begins with one or more numeric characters. The zoom goto works if the first SELECT fields begins with an alphabetic character (among many others) for all returned records. When more than one record matches the zoom goto request, the contents of this field are displayed for the user to choose the map object they want to zoom to.
By "first returned field" we mean the string data returned by everything after "select" and before the first comma as indicated with bold in the following sample zoom goto SQL statements.
select parcel + ' ',lat,lon,lat,lon from landbase
where parcel like trim(ucase('%s%%')) order by parcel
select street_all,lat,lon,lat,lon from stinters
where street_all like ucase('%s%%') order by street_all
select str(street_no) + ' ' + street_dir + ' ' + street_nam,lat,lon,lat,lon from adparcel
where street_nam like trim(ucase('%s%')) order by street_nam,street_no
If a non-breaking space character, literal alphabetic character, underscore, or any of many other characters (except blanks and nulls) is added ahead of the string, the zoom goto works but displays the unwanted character. HOWEVER, unlike other characters that make it work, the non-breaking space still appears as just a space (and a narrow one at that since it's a proportional font). For example, these SQL statements make the zoom gotos work when the string would otherwise start with a numeric character: (Of course we don't want to see leading X's or even underscores in the displayed result list.)
select chr(160) + parcel + ' ',lat,lon,lat,lon from landbase
where parcel like trim(ucase('%s%%')) order by parcel
select 'X' + parcel + ' ',lat,lon,lat,lon from landbase
where parcel like trim(ucase('%s%%')) order by parcel
select '_'+street_all,lat,lon,lat,lon from stinters
where street_all like ucase('%s%%') order by street_all
select str(street_no) + ' ' + street_dir + ' ' + street_nam,lat,lon,lat,lon from adparcel
where street_nam like trim(ucase('%s%')) order by street_nam,street_no
This SP1ZoomGotoBug.mwf MWF file demonstrates the problems for these Zoom Goto categories below and possibly other Zoom Goto categories as well. Indicated values are just sample values to try. If you try the these MWF Zoom Goto's with the version 6.5SP1 Viewer they fail. If you try them with the version 6.5 Viewer, they work.
This SP1ZoomGotoBugFIX.mwf MWF file demonstrates the workaround of appending a non-breaking space character, decimal 160 or hexadecimal A0 entered as chr(160), ahead of the these Zoom Goto categories. This sample MWF works with both base 6.5 Viewer and the version 6.5SP1 Viewer.
Some of the Zoom Goto's work while others fail. Here are a few Zoom Gotos that work in either MWF map with both the version 6.5 and version 6.5 SP1 Viewer:
You can see this on our MapGuide map by clicking here and seeing the problem with the Multiple Listing Service Areas and Supervisor Districts layers. You may need to zoom to the same scale of 1:172,556 to see exactly the same thing. None of the Supervisor District labels (names) should be visible as the Supervisor Districts layer is under the Multiple Listing Service Areas layer.
These bugs may deal with inherent architectural issues or are big changes. As such, they aren't likely candidates.
Note that some of these problems may also exist in MapGuide Enterprise, although we haven't tested against the latest version. They are probably not good version 6.5 "service pack" canditates because they may require major code re-write or design changes.
You can see this on our MapGuide map by clicking here and obseriving the Supervisor Districts layer. The only correct label displayed is that for SHARON BRONSON. You may need to zoom to the same scale of 1:7,741 and adjust your window to the size displayed here to see exactly the same thing. Rebuilding the Supervisor Districts layer may cause more labels to appear (which is another strange anomaly).
The problem can be even more severe as shown in this next example. Since labels may sometimes block other labels, there are situations where the desired label is obscured and only the wrong label is displayed. In this example, note that the green area is actually supervisor ANN DAY, not SHARON BRONSON as labeled. You may be able to see this on our MapGuide map by clicking here and observing the Supervisor Districts layer. It may help to zoom to the same scale of 1:18,152. If you see two supervisor district labels, try panning carefully until one of the labels is under a major road label, while the other is still visible. Depending on how you pan, you can probably obliterate either the correct label or the incorrect label.
This results in the selection of unintended points that are outside of the selection area. The same selection area results in different numbers of points selected at different map scales because the ground area covered by the points symbols varies with scale. Since selections within areas (such as within buffers) are usually used for reporting or analysis purposes, the additional extraneous point features selected can cause dramatic errors in the reported results. Different users who follow the same selection or buffer procedures may get different results because their maps are not displayed at the same, exact scales. An individual user who repeats the process will also get differing results due to a potentially different map scale.
|
||||||
|
(Added 4/22/2011)