Memory Table Name

Enter a name for the memory table that will be used to store the SQL query results.

Scripted Form Caption

Enter a caption to be displayed on the input scripted form created to input parameters. Defaults to Selections on Generate if not entered.

Generate (F9)

The Wizard builds MaxBasic code to create a scripted form to input the parameters, then to execute the SQL code and save the results in a memory table. The Script Editor opens, displaying the generated code.

Generate File Reference

Enabled when a .pfq file has been loaded and there are no unsaved changes.

When Selected, the generated code will execute the .pfq file rather than explicitly include the SQL query.

Grid Fields

Name

The parameter name.

Caption

The caption to be shown on the scripted form. Defaults to the parameter name.

Input Type

Select the type of parameter.

Style

The style of input to be used when prompting for and matching to the parameter.
Select from From, To, Equal, Equal Or All, From Equal or All, To Equal or All.

Note: Use From Equal or All and To Equal or All where you have Between parameters in the query but only want a single Input prompt which if left blank will select From First to Last.

Lookup Source

If available, select the source for the parameter.

If Blank

Action to take if the parameter is not input.

Default Value

Optionally enter a default value for the parameter. If the Input Type is blank, the parameter will be set to this value.

List Values

Optionally enter a list of values to select from.

Grid Toolbar

Expand Toolbar (Ctrl+F9)

Expand the toolbar to give access to all toolbar options. Press Esc to close the expanded toolbar.

Move up / Move down

(Shift+Up)

(Shift+Down)

Move a line up or down the grid.

Customise (Alt+F5)

Opens Customise Fields, you can customise the fields visible in the grid.