Form designer: Stored procedure and linked lists

Process Design Form Designer
1

You can use stored procedure and linked lists. The stored procedure parameter can be used in a dependent drop-down list and the stored procedure parameter is defined and used like it is done for a SQL SELECT statement.

Example

Select command:

  • MS SQL Server:

    EXEC MyStoredProc @MyParam

  • Oracle:

    EXECUTE MyStoredProc :MyParam

Parameters:

  • Name: MyParam

  • Field: REQUEST_MYFIELD