Users can also use the group dialog box launcher or Reload, Configure Parameters. The SaveToDB add-in automatically creates ribbon parameters to change stored procedure parameters. Parameters of Stored Procedures and SQL Codes To input multiple values, click the '.' button and choose the required values: The SaveToDB add-in supports multiple values in the WHERE clause (using the IN keyword). to change the choice and values later.Ĭheck the fields to select in the leftmost S (Select) column.Ĭheck the fields to use in the WHERE clause in the rightmost W (Where) column. Use the Database Connection Wizard to select the fields for the first time and the group dialog box launcher or Reload, Configure Parameters. The add-in places such fields to the ribbon. Users can choose fields to use as WHERE fields. Database developers can configure name translation.
The SaveToDB add-in displays fields and parameters with the native database names by default. Users can define the limit using the Options dialog box. Otherwise, the add-in stores user's values of parameters and shows them in the parameters. Database developers can configure value lists.
The SaveToDB add-in populates parameter values if it can detect source values. to display the Query Parameters dialog box to select and change hidden parameters. Open the group dialog box launcher or Reload, Configure Parameters. When a user changes ribbon parameters, the SaveToDB add-in changes the active query with new values and reloads the data.
0 kommentar(er)
