DatabaseSelect
Data_Access / DatabaseActors
Block Name: DatabaseSelect
Code File Location: VisualSim/actor/lib/database/DatabaseSelect
Select the columns from rows that match the specified pattern via the specified database manager. The output is an array of records, one for each row that matches the pattern. In each record, there is field for each column, where the name of the field is the name of the column and the value is the value from the matching row. If no rows match the specified pattern, then the output is an empty array of the appropriate type.
Parameter |
Explanation |
Type |
Example |
columns |
A record indicating what to query for. The names of the fields are the names of the columns to retrieve from the database, and the value of the field is the type. This is a record that defaults to {LNAME=string, DESKNO=string}, indicating that two columns, LNAME (for last name) and DESKNO (for desk number) should be retrieved from the database. |
||
databaseManager |
Name of the DatabaseManager to use. This defaults to "DatabaseManager". |
||
distinct |
Indicator of whether to return only distinct records. This defaults to false. |
boolean |
|
orderBy |
Optional ordering of the results. This defaults to empty, meaning that the ordering of the results is arbitrary. |
string |
To order first by DESKNO (ascending) and then by LNAME (descending), you would change the value of this parameter to "DESKNO asc, LNAME desc". |
Created with the Personal Edition of HelpNDoc: Full-featured Kindle eBooks generator