SmartMarine 3D - Show recent objects in the work space

| | | |

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.

Smart Marine 3D beginners SQL quick start

| | |

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. Read ItemName from JNamedItem and match the object IDs 'oid' from both tables views.

List registered SQL servers using C#

| | | | |

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.