[Manifold-l] Can't add column to table of linked drawing in oracle

[Albert Tan]

Hi....I have followed the steps that you have shown me and i still cannot
add or edit object to the view drawing but somehow the tools tool bar can be
selected. The object when selected with ctrl + alt, you can see the
coordinates but you cant move them. Any idea whats happening here. Thanks
again for your help.

On 3 Jul 2006 06:55:00 -0700, adamw at manifold.net <adamw at manifold.net> wrote:
>
> > I have created a view in the Oracle using Oracle
> > Enterprise Manager Console and when linked the created
> > view as a drawing I could not add any objects to the
> > drawing and also do editing. I have add the SRID and
> > other metadata into the USER_SDO_GEOM_METADA view
> > and I still can not add any objects or do editing.
>
> You should also let Manifold know about the primary key you used in the
> view.
>
> Here is what I did:
>
> Launched Manifold. Imported a drawing of Mexico (Mexican states). Exported
> the drawing to Oracle accepting the default export options.
>
> Opened Database Console, connected to the Oracle database and created a
> view, taking care to note the primary key column:
>
> CREATE VIEW mv (oid, geometry, version, pop_90, state_name, CONSTRAINT
> mv_pk PRIMARY KEY (oid) RELY DISABLE NOVALIDATE) AS SELECT oid, geometry,
> version, pop_90, state_name FROM mexico WHERE pop_90 < 2000000
>
> Supplied SRID and the location tolerance:
>
> INSERT INTO USER_SDO_GEOM_METADATA VALUES ('mv', 'geometry',
> MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('Longitude', -180, 180, 10),
> MDSYS.SDO_DIM_ELEMENT('Latitude', -90, 90, 10)), 8307)
>
> Then I refreshed the object tree, linked the view as a drawing and tried
> editing existing objects and adding new objects. Everything worked well,
> except that I could not add a new object and immediately edit it without
> doing View - Refresh Data first (a common problem known to occur with
> different data sources for different reasons, which I think in this
> particular case will be mitigated fairly soon).
>
> Does this work for you?
>
> --
> Adam Wachowski
> Manifold Development Team
>
>
>
> _______________________________________________
> Manifold-l mailing list
> Manifold-l at lists.directionsmag.com
> http://www.directionsmag.com/mailman/listinfo/manifold-l
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.directionsmag.com/pipermail/manifold-l/attachments/20060705/5593aa0c/attachment.htm