CAD/CAM | MS SQL | SMART MARINE | SMART PLANT | SMART 3D
Database platform: MS SQL server Product: SmartMarine 3D, SmartPlant 3D (SM3D, SP3D) Task: Show in the work space all objects created or edited recently For troubleshooting and for monitoring purposes it is useful sometimes not only to get a list of the objects created or edited recently, but also to show these objects in the work space.
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.