SoftadminGuide.Generate_Treeview_Sql

Type: Stored procedure

Creates the procedure to retrieve nodes for a "Treeview" menuitem.

Parameters

@AllowDragAndDrop optional sysname

Whether or not drag and drop is enabled for all nodes. Default 0.

@IdColumn mandatory sysname

Name of the Id column in the table.

@LabelColumn mandatory sysname

Name of the label column in the table.

@OverwriteProcedure mandatory bit

Whether or not it is allowed to overwrite an existing procedure.

@ParentIdColumn mandatory sysname

Name of the parent's Id column in the table.

@ProcedureName mandatory nvarchar(600)

Name of the created procedure.

@SortColumn mandatory sysname

Name of the column in the table to use in the ORDER BY clause.

@TableName mandatory nvarchar(600)

Name of the table to base the procedure on.