Some simple SQL queries that can help new users start faster.
Applicable to: SmartPlant 3D , SmartMarine 3D and Smart 3D design systems.
Create equipment list including equimpment description. The information is stored in two different tables in projects' (plants' ) database - XXXX_MDB. The table view JNamedItem contain all items names and their IDs - oid. The equipment data is read from JEquipment. Table view JEquipment has information for the equipment ID but not for its name.
CAD/CAM | MS SQL | SMART PLANT | SMART MARINE | SMART 3D
Applicable to: Smart Marine 3D, Smart Plant 3D using SQL 2005 client
Smart Plant/Marine 3D software require the SQL servers where projects/plants database is located to be registered on each client workstation. In the software version up to 9.1 HotFix: ANY it is required to have also SQL 2005 client installed on the workstation.