Storage of files and long fields in the database - SmartPlant Foundation - IM Update 48 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

Files in SmartPlant Foundation can be stored in physical vaults on the file system or within the database. By attaching the ISPFDBFile interface to a class of file, the file is stored within the database rather than within a vault. This can be an advantage for certain types of files; for example, any files associated with the templates delivered with the default databases are all stored within the database. This is achieved by allowing the <prefix>OBJPRDETAIL table to store binary large objects (BLOB) within it. This table is also used to store any property that is greater than 4000 characters long.