SoftadminGuide.Generate_NewEdit_GetEditFields_Sql

Type: Stored procedure

Creates the GetEditFields procedure for a NewEdit menuitem.
Expects the temp table

CREATE TABLE #GetEditFieldColumns
(
	ColumnName sysname NOT NULL,
	SortOrder int NULL
);

The table may be created from SoftadminGuide.Table_AllColumns or SoftadminGuide.ParseField_Columns (assuming it does not involve any joins). See the documentation of those functions for further explaination of the columns.

Parameters

@OverwriteProcedure mandatory bit

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

@ProcedureName mandatory varchar(600)

Name of the created procedure.

@TableName mandatory nvarchar(600)

Name of the table to base the procedure on.