Rockwell Automation FactoryTalk Historian SE ProcessBook 3.2 User Guide User Manual

Page 285

Advertising
background image

7

Data Streams

267

3. Click File > Return to ProcBook when you are finished.

Microsoft Query cannot edit query statements that contain

placeholders.

If the Design button is disabled, then:

If Microsoft Query is not installed, the Design button is disabled;
however, you can type the query in the query text box. You can also
copy and paste a query from another query building tool.

6. Add or edit the appropriate WHERE clause in the query to edit a

placeholder data set or existing placeholders (question marks represent
placeholders in the query statement).

7. Click Placeholders. This action causes the syntax of the query to be

checked.

If the syntax is valid, then the Placeholders dialog box displays with
the current placeholders. If the syntax is invalid, then an invalid query
message is displayed.

8. Click Check Syntax, to complete a syntax check of your query. The

status of the query is returned.

9. When you have finished modifying the data set, click OK.

If the data set is in use in a display, the Confirm Data Set
Modification
dialog box displays.

10. If you wish to proceed, click Continue. The Data Sets dialog box

appears.

11. Select the column(s) to be used and click OK to return to the dialog

box.

Advertising