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?
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!
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.
Start with some of our most frequented solutions to get help installing your software.