Syntax |
Example |
Description/Remarks |
LIST_Q
|
LIST_Q 1, This example would return a list of template names read from the data file. LIST_Q 1, This example would return a list of template names and their file name separated by commas. LIST_Q 1, This example would return a list of template names with optional items in the list. The first item in the list would be "Go back" followed by the list of templates. The last two items in the list would be "Exit template" and "Exit system". LIST_Q 1, This example would return a list of template names and three extra buttons beneath the list. The three buttons would be displayed in the following order: "Go back", "Exit template", and "Exit system".
NOTE: You can use an unlimited number of "optional_position" and "optional_text" parameters. You can also use multiple "S" and multiple "B" parameters. |
This command executes an SQL statement and displays a list of the values from the first column of all rows in the SQL query result set, as well as values you may specify with "optional_position" and "optional_text" parameters. Alternately, this command can be used with an empty string ("") for the "SQL_statement" parameter, to display a list containing only the values you specify with "optional_position" and "optional_text" parameters.
The "title" parameter sets the list title displayed above the list. You may add buttons to the list window, regardless of the contents of the list. This command returns either the value determined by the LIST_OPT command or an identifier for the button clicked by the operator. When listing the results of an SQL query result set, the LIST_Q command will function correctly only if a connection has already been established with Q_CONNECT. Only the first column of the SQL query result set will be displayed in the list. To display the contents of multiple columns as distinct entries in the list, use the SelectColumns keyword. If there is an error, the listbox will display the error information. When the "SQL_statement" parameter is an empty string (""), the LIST_Q command will function correctly even if a connection has not been established with Q_CONNECT. The "optional_position" and "optional_text" must be used together:
More than one optional entry may be used. The screen containing the list will correctly size itself based on the contents of the SQL query result set and any "optional_text" items added to the list. You can use the LIST_OPT command to modify display settings for the screen containing the list. |
LIST_Q |
LIST_Q 1, This displays a list of the standard variables for all standards that begin with 'Service calls'. If there are two standards that begin with this text, then this list will contain eight values as follows:
|
When used with the keyword "SelectColumns" in the SQL_statement portion of the formula, the list displayed to the data entry operator will contain the specified column values from all rows of the query result set. |
LIST_Q |
LIST_Q 1, This displays a list of defects for process B-MIXING. Additional options can also be added to the start and end of the list, as shown in the following example: LIST_Q 1, |
When used with the keyword "PROCESS[process_name]" in the SQL_statement portion of the formula, the list displayed to the data entry operator will contain the defects associated with the specified process_name. Even though a connection_number is required in the command syntax, LIST_Q with the PROCESS[process_name] option will automatically access the connection and table name information used to log in to the SPC Data Entry module. Error conditions that are trapped and return specific messages in the list are:
If changes are made to the list of defects for any process, these changes will be reflected the next time the SPC Data Entry module is launched. |
LIST_Q |
LIST_Q 1, This displays a list of all the values stored in MySArr "MyList" Additional options can also be added to the start and end of the list, as shown in the following example: LIST_Q 1, |
When used with the keyword "array[array_name]" in the SQL_statement portion of the formula, the list displayed to the data entry operator will contain all the values in the MySArr specified by array_name. Even though a connection_number is required in the command syntax, LIST_Q with the "array[array_name]" option will not use the connection.
Values in the list are sorted in order from lowest to highest index. They are not sorted based on the value. |