Query Detail Pane

When a query node is selected in the schedule tree, its definition appears in the detail pane.

Query Description

Describes the purpose of the query to system users; MES automatically assigns an ID number to identify it in the data records.

Query Type list

The type of query that will be accessing the MES database.

SQL Statement

Uses standard SQL selection syntax.

Stored Procedure

Uses a pre-defined stored procedure.

Middleware Method

References a call to a method complied in the MES COM + application.

The remaining fields will appear, as needed, depending on the chosen query type.

Query Type = SQL Statement

SQL Statement

The query using standard SQL selection syntax. The query may contain parameter names, denoted by the @ symbol as the first character.

Parameters grid

The parameters used in the SQL query.

• Parameter: The parameter name, identified in the query by the preceding @ symbol. This parameter substitutes the value to the inline query while executing the query.

• Parameter Type list: The data type of the parameter.

• Default Value: The default value to be used for a required field that is missing from the source.

Query Type = Stored Procedure

Stored Procedure

The name of the stored procedure that will be run as the query.

Parameters grid

The parameters passed, in order, to the stored procedure.

• Parameter: The stored procedure parameter name.

• Parameter type list: The data type of the parameter.

• Size: The space to allocate in bytes for the parameter.

• Default value: The default value to be used for a required field that is missing from the source.

Query Type = Middleware Method

DLL list

Indicates which available MES middleware DLL will be used.

Object (Class) Name list

Indicates which object, of those exposed by the selected DLL, will be used.

Parameters in XML

Lists all required and optional XML tags for the selected middleware object. Allows you to assign values to these tags.

Running the Query

Click the Test button to run the query. The parameters will be passed with their configured default values. The Result window appears, displaying the data returned by the query.

To modify the query, select the desired field and change its value. Click Save to keep your changes or Cancel to discard them.