Bruce, Please zip up and send me via private message... Your modified MVBA file. A sample design file containing the original MicroStation shape elements. A current copy of your Bentley Geospatial Administrator schema file. ...and I will…

...select the Bentley.Geospatial.Extensions.Oracle.tlb type library when setting your reference.

Holger, First of all thank you for your valuable feedback, much appreciated. Next, as previously mentioned, at this time unfortunately the ability to perform a DBMS_WM.RefreshWorkspace call from the Bentley Map Interoperability user interface is not…

Tom, Yes, in the forthcoming Bentley Map V8 i (SELECTseries 3) 08.11.09 release, a warning message will be displayed to the user when attempting to query 3D data into a 2D design file.

Krister, You will first need to grant each user the required privileges for the table(s) and sequence(s) (if INSERT is required) object(s) from your master schema. Then view(s) are created with disabled primary key constraints that are named the same…

Stefan, The Interoperability functionality of Bentley Map is not currently available in VBA directly. However the Interoperability application (e.g. gdi) provides keyins which could be used in VBA to perform basic queries of feature instances from…

Gerald, First thank you clarifying what was actually occurring. I wanted to ensure that you were aware of the purpose of "Propagation Rules" so that you could apply them as desired in your workflows. Next, the copied feature instance should be seen…

Ian, A couple of approaches come to mind. You could register those additional Oracle Spatial features in the Bentley Geospatial Administrator as you would normally do with the exception of assigning a sequence generater to the layer. By skipping…

...to limit the scope of feature classes discovered during the "Register Features" process, use a user account that does not have DBA privileges. For example, using the following privilege assignments... GRANT DELETE ON MYSCHEMA.MYTABLE TO MYUSER;…

Krister, Once connected to Oracle Spatial those newly created feature instances are seen as potential inserts into the remote repository. By default Bentley Map works in short transaction mode, meaning that changes must be posted or discarded when…

Stefan, You will most likely have to use regasm.exe to manually register the generated type library, something that is done automatically when Visual Studio compiles the assembly if the projects "Build > Output > Register for COM interop" option is…

...unfortunately, at this time I don't believe there is a way to restrict the discovery process, but I will do some additional checking to verify that. While we're discussing this topic, how would you as an "Administrator" or "User" prefer to control…

Bruce, Only those tables containing Oracle Spatial SDO_GEOMETRY data types are supported directly in Bentley Map. I would expect that use of the Bentley ProjectWise Connector for ArcGIS would be required.

...you could try to set the _USTN_USERNAME environment variable to the name of the user workspace (e.g. SET _USTN_USERNAME=geo_example_designer) in the shell before starting your session.

Adrian, In the Bentley Geospatial Administrator, you should be able to assign an Oracle sequence generator during the "Register Features..." process for this. Before registering your feature, be sure you have created the sequence in your database using…

...okay very good Stefan, thank you for that confirmation.

Jiri, For the following compound geometry... SHAPE(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES) --------------------------------------------------------------------------------------------------------------------------…

...will also add that Bentley Map supports the use of Oracle oriented points described here to persist the rotation of the feature instance.

Greetings Veeresh, Have you any custom code involved or are you only using standard Interoperability functionality? Could you provide the exception.log that was generated?

Holger, At this time the ability to perform a DBMS_WM.RefreshWorkspace call from the Bentley Map Interoperability user interface is not supported, but is being considered for inclusion in a future release based upon overall customer demand. Could you…

Krister, I've posted a complete example here which includes a sample COM server written in C# which demonstrates one approach to calling the Bentley Map Interoperability managed API methods from VBA. The following sample VBA form should give you some…

Jakob, A few questions. Do both views refer to the same base table? Is each view defined in such a way as to guarantee that all rows returned contain the same geometry type? For the AFL_BROEND feature class, what is the layer_gtype parameter…

Rob, I've not heard of that particular scenario, and you're correct, after the post operation the feature instances should be locked once again, preventing modification in the local design file cache. What version of Bentley Map are you using?