[fdo-users] Managing Data with Joins

[Mike Toews]

Hi,

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.

-Mike

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
common
> 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:
http://n2.nabble.com/Managing-Data-with-Joins-tp4681780p4681780.html
> 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