Get from Database Field

Looks up a nominated field in a database, and write the value returned to a Global Data Item. The SQL Database must be already referenced through the SQL Database Queries field (see Object menu). Each iteration returns the next value in the database.

Parameters

• Simul8 Global Data Item: Variable to receive the data from the database
  
• Simul8 SQL database: Name of the database to retrieve data from
  
• Field: Field to query

• Complete SQL Insert or Update
• Insert into SQL Database
• Open database
• Set Field Text
• Set Field Number
• SQL Command
• Update SQL Database
• Set SQL Database Login Credentials

• SQL