[fdo-users] Managing Data with Joins

Mike Toews mwtoews at gmail.com
Wed Mar 10 10:57:18 EST 2010


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.

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.


On 5 March 2010 08:19, brujulas <gis at cadmax.es> wrote:
> Hi,
> Good afternoon, I'm having many problems with projects that have data
> attached by joins::working:
> The scene is geometry in Oracle with an ID and alphanumeric data attached,
> and on the other hand a database in Access (connected by ODBC) with a
> Id
> - Ýou can't edit geometry.
> - You can't query data joined.
> - You can't split or merge geometries.
> Has anyone managed to fix these constraints of Autocad Map??
> Excuse me for my poor english
> Greetings
> --
> View this message in context:
> Sent from the FDO Users mailing list archive at Nabble.com.
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20100310/9c0a5922/attachment.html

More information about the fdo-users mailing list