Product(s): | Bentley Facilities Space Planner | ||
Version(s): | 08.11.11.23 | ||
Environment: | N\A | ||
Area: | database | ||
Subarea: | N\A |
Problem
We have a column within the Bentley Facilities database that is set to 6 characters in length. We need to expand this length to 15 characters. If we were to perform an alternate command in SQL and change this column to 15 characters would this impact anything else within Bentley Facilities database?
Solution
Yes, this will impact Facilities as well. The ProjectWise schema defines which database tables and columns are accessed and how. This also will limit writing to this extended column more than 6 characters.
Unfortunately, ProjectWise Class Editor does not allow changing attribute size. Creating a new attribute as a replacement would be an option, or deep internal SQL clauses (which are not supported). So, the adding a of a new attribute with correct length and removing the old one is recommended. Whether it allows using the same column, would need to be tested.