Applies To | |||
Product(s): | MicroStation | ||
Version(s): | 08.05.02.35 | ||
Environment: | N\A | ||
Area: | Database | ||
Subarea: | VSQL | ||
Original Author: | Bentley Technical Support Group | ||
How to place MicroStation points using database records ?
1. Connect to the database in MicroStation (Settings > Database > Connect)
2. Settings > Database > Query Builder
3. Execute a query on the easting, northing or XY coordinates in the appropriate table.
4. In Visual SQL Query Builder select Queries > Save Results.
5. Save the results as a delimited .DAT file.
6. Edit the .DAT file and remove the first line containing the table and column names.
7. In MicroStation select Tools > Annotation > XYZ Text.
8. The Import setting should be Point. The Order should be set to the appropriate XYZ or YXZ.
9. Set the appropriate symbology and click Process.