Autodesk MapGuide Enterprise

[#1]

I am trying to theme a layer based on a join between a SQL table via DSN and an sdf. I only want to return results where a uniqe ID field is equal to 9 as the SQL table consists of thousands of records that are irrelevant to this particular thematic. However when I try to apply a filter to the property which is an int32, i get an error message saying, "An exception occured in FDO component. Property 'CommunityID' is not found. I can't seem to get the filter to work for any of the fields in the SQL table. Any help?

Thanks,

Jaime

[#2]

Don't know if you found a solution to this yet, we are experiencing a similar issue.

please let me know if you found a solution or if anyone knows. thank you!

[#3]

I have had similar issues, I usually have to create a view in SQL Server to remove the offending Fields that are causing the issue and join my data to that new view to work around it.