& Construction
Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
& Manufacturing
Professional CAD/CAM tools built on Inventor and AutoCAD
Fix validation errors for multiple bridges using SQL.
Tutorial resources
These downloadable resources will be used to complete this tutorial:
Fix validation errors for multiple bridges using SQL.
Once bridges have been added to a network model in ICM, there may be validation errors that need to be fixed. To complete this exercise, copy the data from the transportable database .icmt file for this tutorial.
Two bridges have just been added to this model. To fix the remaining roughness validation errors for both bridges:
In the Output window, notice the illegal or missing roughness value errors against all the bridge section data.
SET us_link_section.roughness_N =0.05;
SET us_bridge_section.roughness_N =0.03;
SET bridge_deck.roughness_N =0.01;
SET ds_bridge_section.roughness_N =0.03;
SET ds_link_section.roughness_N =0.05;
There should be no more errors.
Only the connectivity errors should remain.
Note that the use of an SQL only allows the assignment of a single value to the entire section. If more detail is required, this should be updated manually, or it could have been included in the original survey data import.