Ribbon Parameters

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 may 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 may 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

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 may use the group dialog box launcher to configure parameters.

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

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.

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:

Web Query Parameters

The add-in detects URL parameters automatically.

You may configure parameters using the Connection Wizard.

The real URL of the example above is

https://finance.yahoo.com/q/hp?s=GOOG+Historical+Prices

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

During the connection, the URL was configured as

https://finance.yahoo.com/q/hp?s={Symbol=GOOG}+Historical+Prices

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 may use the Query Parameters dialog box.

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

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

Text Query Parameters

You may 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.
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.