Unexpected function type.

The function type created must match the selected new function type.

When you create a new function, the menu provides three choices:

  • New Inline Function.

  • New Table-valued Function.

  • New Scalar-valued Function.

The SQL syntax you use to create the new function must be compatible with the initial menu choice.

To correct this error

  1. Modify the SQL syntax to match the selected function type.

    -or-

  2. Delete the current function and select another function type.