As you continue recording the query, you are prompted to enter an example value for this variable. Note that the values you enter are used in the recording session, but are not retained as part of the macro. You must use the query bar for this task. The illustration below shows a Query window with a variable specified in the Submitter field. Select Start Recording from the Macros menu.
Recording appears in the status area at the bottom of the Main window.
Activate or open a Query window that contains your desired schema. Specify the search criteria you want. Prompt to Enter Example Value Enter an example for each of the prompted variables. The examples you enter are not stored with the macro. They only allow you to continue with the recording session.