VBA check if a feature is queried from database
Hello all,
I have a features queried from database and another I just placed. Can I check if feature is queried from database in VBA?
Unable to post feature received message as“Error Inserting Feature (class: table_name, id: ) XX000: Polygon must have at least four points in each ring”.
If you receive message as “Error Inserting Feature (class: table_name, id:000 ) XX000: Polygon must have at least four points in each ring” while trying to post a feature. This error can occur if there are multiple geometry columns in current spatial…
- Error "Cannot display the specified content in the grid.”
You receive an error “Cannot display the specified content in the grid” when querying features from the database or using the Data Browser to retrieve attributes on selected features. This error is very generic, it can occur if
Null value in date…
Joining Spatial and Tabular Data from USDA NRCS Web Soil Survey
Using OpenCities Map Advanced. Downloaded county-wide spatial and tabular soil survey data from the USDA NRCS Web Soil Survey. The tabular data is in *.mdb format. How do I pull the *.mdb file data into the dgn map to associate it with the spatial data…
- Disable Connect to Database dialog
![Kees van Prooijen [Bentley]](https://communities.bentley.com/cfs-filesystemfile/__key/communityserver-components-imagefileviewer/communityserver-components-avatars-00-00-00-81-26/4TV0A7TO96SY.png_2D00_44x44x2.png?_=635664938801836812)
The Connect to Database dialog appears when DGN file opened or a DGN file is referenced that contains a (non-graphic) MicroStation startup database element.
To disable the Connect to Database dialog, set the following variable: MS_GEOXFM_DISALLOW_INFERRED_DBCONNECTION…
- Automatically connect to a graphical source
It is possible to set up OpenCities Map so that every time a DGN is opened, a connection is established to a graphical source such as Oracle Spatial, SQL Server Spatial, PostGIS, OGC WFS, or Esri File Geodatabase
To do this, first define the named graphical…
RE: [BM SS4] What happens to User Data Linkages?
Bruce,
During the "Promote" process the database linkages should be preserved and remain available on the elements. However database linkage information is not automatically available on the feature instance or inserted into the spatial database during…
RE: Store attributes in a database
Morten,
To insert database rows during "Import" operations in the Bentley Map Interoperability application use the "Feature Parameters > Mapped Name" and "Property Parameters > Mapped Name" sections to assign feature class and business property mappings…
Re: Connecting to the SAME Row in an ODBC connected Database
My apologies! Certainly what you are asking is a valid application. Essentially a one-to many relationship. It is something MicroStation has supported for a long time with the idea of duplicate linkages. Here's my thinking on the subject.
As I mentioned…
Deleting a feature with confirmation
Hi
We have set up GSA features with several database properties linked to MSSQL.
I would like to know is when you select and delete a feature (which deletes a database entry directly without the ability to undo) is there some mechanism by which…
Re: Connecting to the SAME Row in an ODBC connected Database
True enough. Not everyone runs on the calendar year. We are expecting the release towards the end of June this year.
In your example below, you want to associate a series of features with a record that indicates when those features may have been…
Re: What is Database linkages? What mean is?
...the " Associate Linkages " tool is used to copy database linkages to/from centroids, boundaries and/or area elements using any of the following modes.
Centroid -> Shape - copies the database linkages from centroid elements to shape elements…
Re: feature propertу in Bentley Map
Database linkages: MSLink and EntityNum
Mira:
Bentley PowerMap has linkage with the MDB, and features were registered in MDB.
Bentley Map has linkage with the database on SQL-server.
I copy feature property from MDB to SQL-server.
It…
Re: visual query builder
...are you using a MicroStation database connection? If you enter db=? at the uStn> prompt, do you see the name of your database connection? The Visual Query Builder only supports database connections made through standard MicroStation database functionality…
Re: Connecting to the SAME Row in an ODBC connected Database
Here is some information from the Bentley Map help that may be of assistance.
Bentley Map Operation with RDBMS
Bentley Map tries to maintain the concept of one data base record for each graphic record. That means when starting a project…
Re: Geospatial Administrator existing dgn file
If the DGN is already connected to Access then you need to define the database in the XFM project. To do so, go to the database node in the GSA and add the ODBC data source name. Create a feature that describes one of the features in your existing DGN…
Re: Howto configure Bentley Map?
Morten,
You should be able to define the following configuration variables (those highlighted) MS_GEODBCONNECT, _USTN_DATABASENAME and MS_GEOINITCMD to automatically perform the database connection and prevent the display of the "Connect to Database…
Re: Howto configure Bentley Map?
Morten,
First the Bentley Map and MicroStation database connections are one in the same. Next you can add the following configuration variable...
MS_GEOXFM_DISALLOW_INFERRED_DBCONNECTION = 1
...to your workspace or ustation.exe startup command…
Re: Building polygon feature and transfer attributes
Hi,
In both solutions propose by Jerry, you should be connected to the Access database.
After shapes are created by Create Shape tool, you can use Associate Linkages tool from Topology Creation toolbar by using the Centroid -> Shape; that…
Help with creating DB
Hello,
Im working with street light infrastructure.
Recently ive got the Bentley Power Map v8i tool to work with.
I see thaat there is a posibility to add a db to it.
But here is the catch, for the moment I was working with raster map images…
work flow for linking imported database records
We are in the process of moving from GeoGraphics to BentleyMap (with BentleyWater). I am concerned about a workflow that we had using GeoGraphics. Maybe someone can get me going in the right direction to accomplish the same goal.
We have information…
Re: Converting XFM Info to ODBC Database?
Alan,
The Bentley Map feature model supports the use of RDBMS persisted business properties as well, not just with Oracle Spatial persistence. Database tables and properties can be associated with a feature class using the Bentley Geospatial Administrator…
(GeoGraphics) HOW DO I : Connect to and Dump elements into an Access Database
Alright,
I've been a GeoGraphics user since about 2006. We have a strict workflow in our department that doesn't encourage familiarity with the database. Use the Spatial Query and Post tools, fill in the attributes in our prepared forms, and that's…
Re: What is Database linkages? What mean is?
MicroStation and Database Linkages
herovn:
But I don't understand it well.
LIke many Bentley products, the Geo family relies on the MicroStation platform.
MicroStation has built-in capability to connect to a relational database (DB) such…
Re: Is it possible to convert database attribute to DGN?
Hi,
In GeoSpatial Adminsitrator, we can define a database (RDBMS) attributes as database property for a feature XFM. Once conencted to database, you can add a database property and SQL Statements.
In the GSA help file, go to the following…