I've successfully created a spatial view of a feature class stored in one of the project's GDBs. However, this particular feature class has attachments and I don't particularly want to lose that information (in fact, we can't! It's needed for the project). My initial question:
- Can you even maintain attachments using spatial views (so, for example, when you use the Info tool on a polygon from the view you can still see its attachments)
If that's possible, how? I've tried to create a view running the following SQL and the view returns 0 results.
CREATE VIEW BridgeDecks AS SELECT br.OBJECTID, br.STR_NAME, br.Shape, brAtt.REL_OBJECTID, brAtt.ATTACHMENTID, brAtt.ATT_NAME, brAtt.CONTENT_TYPE, brAtt.DATA, brAtt.DATA_SIZE FROM ProjName_Assets.dbo.ProjName_BRIDGEDECKS_MASTER AS br, ProjName_Assets.dbo.ProjName_BRIDGEDECKS__ATTACH AS brAtt WHERE br.OBJECTID = brAtt.REL_OBJECTID AND br.OBJECTID IS NOT NULL;
Any pointers would be just wonderful! Some notes for clarification...
ProjName_BridgeDecks_Master is the feature class
ProjName_BridgeDecks__Attach is the table
ProjName_BridgeDecks__AttachRel is the relationship class that appears in ArcCatalog, though it's not used in this sql