Ribbon Parameters

Ribbon Parameters

Example of ribbon parameters

The Parameters group displays:

  • Selected fields of tables and views.
  • Stored procedure parameters.
  • Web query parameters.
  • Text query parameters.

When the query parameter is changed, the SaveToDB add-in changes the active query with new values and reloads the data.

Only the six selected parameters are displayed on the ribbon.

You can change other parameters using the Query Parameters dialog box that is displayed by the group dialog box launcher.

SaveToDB stores user's values of parameters and shows them in the parameter value lists.

You can define the stored value limit using the Options dialog box.

By default, SaveToDB displays native database names of the fields and parameters.

The parameter names can be translated into a business language. See Configuring data translation.

Fields of Tables and Views

Example of applied WHERE ribbon parameters

For database tables and views, the ribbon displays fields that are selected by a user or predefined by an application developer.

Use the Data, Reload, Configure Parameters dialog box for the first time.

When the Parameters group is displayed, you can use the group dialog box launcher to configure parameters.

Example of the query parameters form for views

Check the fields that should be selected in the S (Select) field.

Check the fields that should be used in the WHERE clause in the W (Where) field.

Database developers can configure what fields should be displayed. See Configuring parameter value lists.

By default, the parameter value lists display unique column values.

Parameters of Stored Procedures and SQL Codes

Example of ribbon parameters

Stored procedure and SQL code parameters are detected automatically, and the first six parameters are placed on the ribbon.

The Query Parameters dialog box can be used to change any number of stored procedure parameters.

Example of the query parameters form for stored procedures

By default, a user can specify any parameter value of a proper data type.

Database developers can specify queries that are used for populating parameter values. See Configuring parameter value lists.

In such case, the parameter values are predefined, and users can select values from the lists only.

Otherwise, users can edit parameter values themselves using the '...' button shown above.

The button shows dialog boxes like the following:

Example of Parameter Value Editor form

Web Query Parameters

Example of HTTP query ribbon parameters

The add-in detects URL parameters automatically.

You can configure parameters using the Connection Wizard.

The real URL of the example above is


It has the "s" parameter with the "+Historical+Prices" suffix to the stock symbol.

During the connection, the URL was configured as


Symbol is a new parameter with the default value equal GOOG.

As a result, a user can change the query parameter using stock symbols only.

If the query has many parameters, you can use the Query Parameters dialog box.

Example of the query parameters form for web queries

The SaveToDB add-in reloads web data and preserves table formatting and structure.

So, you can insert your formula columns, apply formatting, filter values and so on.

Text Query Parameters

You can use ribbon parameters to change file names and code pages of text file queries.

See Configuring parameter value lists.

Sorting Rules

The parameter values populated by stored procedures or SQL codes are displayed in the order defined by the procedures or SQL codes.

Other parameter values, manual and populated by views, are being sorted automatically with the following rules:

  • Text values are being sorted from A to Z.
  • Date and time values are being sorted from newest to oldest.
  • Other values are being sorted from smallest to largest.