SIMPROCESS Advanced Feature

Database Interfacing

Using Expressions you can retrieve information from an SQL database, and you can modify an SQL database by inserting into tables, deleting from tables, and updating tables. Knowledge of SQL is required since all queries to the database are SQL queries. Database System Methods - There are six database-related System Methods, which can be used in Expressions:

• OpenDatabase
• CloseDatabase
• ReadFromDatabase
• WriteToDatabase
• GetNext
• GetResult