Stored Procedure Configuration for Auto Numbering Dialog Box

Use the Stored Procedure Configuration for Auto Numbering dialog box to execute a stored procedure on the Vision database. For the Vision auto numbering feature, the stored procedure must return one output parameter.

Location

To display the dialog box:

  1. From the Vision Navigation menu, click Configuration > General > System Settings.
  2. Click the Numbering tab.
  3. In the Numbering grid, select the row to which you want to add the action.
  4. In the Auto Number Source field, select Stored Procedure.
  5. In the Auto Number Format box, click .

Contents

Field Description
Stored Procedure Enter the name of the stored procedure. The arguments for the stored procedure appear in the Arguments grid.
Arguments Drop-down

Click the drop-down arrow on a grid header to complete any of the following actions:

  • To print grid data, click Print. On the Print Preview form, click File > Print to send the grid data to your default printer.
  • To export grid data to an Excel spreadsheet, click Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
  • To turn on grouping for a grid, click Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.

Not all options are available on all grids.

Arguments

The list of arguments populates automatically, based on the stored procedure selected.

  • Name: This is the name of the argument.
  • Value: This is the SQL expression, used to determine the value of the argument at run time. Click the detail button in this field to display the SQL Expression Builder to define the values.