[mapguide-users] Debug JOINed feature class errors
nico at langhirano.it
Wed Mar 28 12:54:42 EDT 2007
I am trying to extend the informations of a layer with additional data
coming from a MySQL table, but I am having trouble making things work.
I created a Data Connection to an ODBC MySQL connection to my db, and
I used it to create a new Join in the sdf data connection.
In the corresponding layer definition I can see the newly created
feature source based on the JOIN, but when I select it I get this
error "You are about to change to an incompatible data resource.
Procceed and set the layer to default?" If I click yes, I can see the
newly added data fields coming from the MySQL table in the property
list, but nothing else: the layer disappears from the preview pane,
and in the log I see something like:
Error: Failed to stylize layer: LayerDefinition1
- MgStylizationUtil.StylizeLayers line 993 file
to stylize layer: LayerDefinition1
Is it necessary that the two JOINed fields have a primary key? The one
in the MySQL table has only an UNIQUE key.
Sorry for the probably lame question, but I am stuck. Thank you in
advance for any suggestion.
More information about the mapguide-users