Table of Contents
- Introduction
- Tutorials
- Introduction to Tutorials
- FlexSim Basics Tutorials
- FlexSim Healthcare Tutorial
- Task Logic Tutorials
- Process Flow Tutorials
- Additional Tools Tutorials
- Tutorial 1 - Conveyors
- Tutorial 2 - The Statistics Collector
- Tutorial 2 Overview
- 2.1 - Build an Average Content Collector
- 2.2 - Build an Output Collector
- 2.3 - Build a Content Over Time Collector
- 2.4 - Build an Orders In Progress Collector
- 2.5 - Build and Orders By Size Collector
- 2.6 - Build a Pick Time By Type Collector
- 2.7 - Build an Average Content By Type Collector
- 2.8 - Build a Content By Type Over Time Collector
- 2.9 - Build an Output By Hour By Type Collector
- Tutorial 3 - Emulation
- Tutorial 4 - Experimenter / Optimizer
- The FlexSim User Interface
- Simulation Best Practices
- Using 3D Objects
- Connecting 3D Object Flows
- Building the Model's Logic
- Working With Task Executers
- Getting Data from Your Model
- Using FlexSim Healthcare
- Reference
- System Requirements
- Release Notes and History
- General Model Settings
- 3D Objects
- Process Flow Activities and Shared Assets
- People Objects
- 3D Objects
- Process Flow Activities
- People Tables
- People Table Concepts
- Person Labels
- Person States
- Person Milestones
- Person Travel Distance
- Person Wait Times
- Census History
- Staff Groups
- Staff States
- Staff State History
- Staff Travel Distance
- Person Wait for Staff History
- Location Groups
- Location States
- Location State History
- Location Census History
- Location Staytime History
- Person Wait for Location History
- Transport Groups
- Transport States
- Transport State History
- Transport Travel Distance
- Person Wait for Transport History
- Equipment Groups
- Equipment States
- Equipment State History
- Equipment Travel Distance
- Person Wait for Equipment History
- Line Census History
- Line Staytime History
- People Templates
- People Template Concepts
- Person Templates
- Average Staytime Bar
- Staytime Box Plot
- Average Milestone Times Bar
- Average Milestone-Milestone Times Bar
- Milestone-Milestone Times Box Plot
- Average Time in State Table
- Average Time in State Pie
- Average Time in State Bar
- Average Distance Table
- Average Distance Bar
- Average Wait Times Table
- Average Wait Times Bar
- Census Bar
- Census vs Time
- Model Throughput Table
- Model Throughput Bar
- Staff Templates
- Staff State Templates
- Staff Avg State Table
- Staff Avg State Pie
- Staff Avg State Bar
- Staff Avg State (Availability) Table
- Staff Avg State (Availability) Pie
- Staff Avg State (Availability) Bar
- Staff Avg State (Combined) Table
- Staff Avg State (Combined) Pie
- Staff Avg State (Combined) Bar
- Staff Utilization (Combined) Box Plot
- Location Templates
- Location State Templates
- Location Avg State Table
- Location Avg State Pie
- Location Avg State Bar
- Location Avg State (Availability) Table
- Location Avg State (Availability) Pie
- Location Avg State (Availability) Bar
- Location Avg State (Combined) Table
- Location Avg State (Combined) Pie
- Location Avg State (Combined) Bar
- Location Utilization (Combined) Box Plot
- Waiting Line Templates
- People Settings
- Tools
- Properties Panels
- Task Sequences
- Tools
- Agent System Tool
- AGV Network Tool
- A* Navigation
- Calculated Table
- Code Editor
- Color Palettes
- Conveyor System Tool
- Database Connectors
- Down Behaviors
- Edit Selected Objects Tool
- Empirical Distribution
- Emulation
- Event List
- Event Log
- Excel Interface
- Experimenter and Optimizer
- Find Objects Tool
- Global Lists
- Global Tables
- Global Variables
- Groups
- Lights
- Measure and Convert Tool
- Memory Profiler
- Milestone Collector
- Model Triggers
- Model Parameter Tables
- MTBF/MTTR
- Performance Measure Tables
- Performance Profiler
- Presentation Builder
- Process Flow Variables
- Property Tables
- Script Console
- Simulation Control Bar
- Statistics Collector
- Storage System
- Time Tables
- Tracked Variables
- User Commands
- User Events
- Video Recorder
- Visio Importer
- Web Pages
- Legacy Tools
- Dashboard
- Charts
- Chart Templates
- Chart Templates
- Content Templates
- Output Templates
- Output Table
- Output Bar
- Output per Hour Table
- Output per Hour Bar
- Output per Hour vs Time
- Composite Output Table
- Composite Output Bar
- Composite Output per Hour Table
- Composite Output per Hour Bar
- Composite Output per Hour vs Time
- Output by Type Table
- Output by Type Bar
- Output per Hour by Type Table
- Output per Hour by Type Bar
- Output per Hour by Type vs Time
- Staytime Templates
- Staytime Table
- Staytime Bar
- Staytime Per Hour
- Staytime vs Time
- Staytime Histogram
- Composite Staytime Table
- Composite Staytime Bar
- Composite Staytime per Hour vs Time
- Composite Staytime vs Time
- Composite Staytime Histogram
- Staytime by Type Table
- Staytime by Type Bar
- Staytime per Hour by Type vs Time
- Staytime by Type vs Time
- Staytime By Type Histogram
- Item Trace Gantt
- State Templates
- Zone Templates
- Milestone Templates
- Travel Distance Templates
- Widgets
- Coding in FlexSim
- Writing Logic in FlexSim
- Basic Modeling Functions
- Debugging
- Essential FlexScript Class Reference
- Full FlexScript Class Reference
- Command Reference
- Developer and Advanced User Reference
- Modules
- RailWorks
Database.Connection
Description
A class for connecting to and querying a database.
Every database connector that you create in your model's toolbox will have a Database.Connection associated with it. To access the connection associated with a connector, use the name-based constructor, providing the name of the database connector.
Database.Connection con = Database.Connection("DBConnector1");Properties
| isConnected | 1 if the connection is currently connected, 0 otherwise. |
Methods
| connect | Attempts to connect to the database. |
| disconnect | Disconnects from the database. |
| prepareStatement | Creates a new Database.PreparedStatement object for executing the SQL statement. |
| query | Executes a SQL query, returning the result. |
Constructor
| Database.Connection | Retrieves the connection associated with a named database connector. |
Details
Do no remove, this fixes the anchor on doc.flexsim.com
Database.Connection.isConnected
readonly int isConnected
Description
1 if the connection is currently connected, 0 otherwise.
Do no remove, this fixes the anchor on doc.flexsim.com
Database.Connection.connect()
| int connect( ) |
Returns
| int | 1 if successful, 0 otherwise. |
Description
Attempts to connect to the database.
Do no remove, this fixes the anchor on doc.flexsim.com
Do no remove, this fixes the anchor on doc.flexsim.com
Database.Connection.prepareStatement()
| Database.PreparedStatement prepareStatement( string sqlStatement ) |
Parameters
| sqlStatement | The SQL statement to be executed by the Database.PreparedStatement. |
Returns
| Database.PreparedStatement | A newly created Database.PreparedStatement. |
Description
Creates a new Database.PreparedStatement object for executing the SQL statement.
Prepared statements are bound to the tree. A connection will automatically remove all its prepared statements when it is disconnected.
Do no remove, this fixes the anchor on doc.flexsim.com
Database.Connection.query()
| Database.ResultSet query( string sqlQuery ) |
Parameters
| sqlQuery | The SQL query to execute. |
Description
Executes a SQL query, returning the result.
Do no remove, this fixes the anchor on doc.flexsim.com
Database.Connection Constructor
| Database.Connection( string connectorName ) |
Parameters
| connectorName | The name of the connector whose connection should be retrieved. |
Description
Retrieves the connection associated with a named database connector.
Database.Connection con = Database.Connection("DBConnector1");