Hi,<div><br></div><div>I have the same limitations within Map, in particular to query for features based on a joined attribute (for many-many relations). However, my workaround is to create a database view. Fortunately, FDO and Map don't seem to mind that my "primary key" repeats throughout the joined feature dataset created from a many-many database view.</div>
<div><br></div><div>However, since it is only a workaround for querying, it won't directly help you with your other issues, and requires all the data to be transfered from Access to Oracle to create the database view.</div>
<div><br></div><div>-Mike</div><div><br></div><div>On 5 March 2010 08:19, brujulas <<a href="mailto:gis@cadmax.es">gis@cadmax.es</a>> wrote:<br>><br>> Hi,<br>> Good afternoon, I'm having many problems with projects that have data<br>
> attached by joins::working:<br>> The scene is geometry in Oracle with an ID and alphanumeric data attached,<br>> and on the other hand a database in Access (connected by ODBC) with a common<br>> Id<br>><br>
> - Ýou can't edit geometry.<br>> - You can't query data joined.<br>> - You can't split or merge geometries.<br>><br>> Has anyone managed to fix these constraints of Autocad Map??<br>> Excuse me for my poor english<br>
> Greetings<br>><br>><br>> --<br>> View this message in context: <a href="http://n2.nabble.com/Managing-Data-with-Joins-tp4681780p4681780.html">http://n2.nabble.com/Managing-Data-with-Joins-tp4681780p4681780.html</a><br>
> Sent from the FDO Users mailing list archive at Nabble.com.<br>> _______________________________________________<br>> fdo-users mailing list<br>> <a href="mailto:fdo-users@lists.osgeo.org">fdo-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/fdo-users">http://lists.osgeo.org/mailman/listinfo/fdo-users</a><br>><br><br></div>