SoftadminGuide.FieldStandard_Columns

Type: Stored procedure

Creates a standardized control to pick multiple columns.

Expects a table #SoftadminGuideMultiControl created by SoftadminGuide.Field_MultiControl_Definition.

Example

/*
    Creates an input field begging for a table name.
*/
EXEC SoftadminGuide.FieldStandard_Table_Create 
	@FieldName = 'TableField',
	@Label = 'Choose a table';

/*
    Creates a checkbox tree, populated with all columns of the selected table.
    The @CustomWhere restricts the choise to columns of type varchar,
    beginning with 'A'.
*/
EXEC SoftadminGuide.FieldStandard_Columns_Create
	@FieldName = 'ColumnField',
	@Label = 'Choose column',
	@TableFieldName = 'TableField',
	@CustomWhere = 'TY.name = ''varchar'' AND C.name LIKE ''A%''';

Parameters

@FieldName mandatory varchar(1000)
The field name, used to refer to this field by other fields and when getting the value from the multi-control.
@Label mandatory varchar(1000)
@TableFieldName mandatory varchar(600)
The field name of a field created using SoftadminGuide.FieldStandard_Table_Create.
@JoinsFieldName optional varchar(600)
The field name of a field created using SoftadminGuide.FieldStandard_TableJoins_Create.
@Description optional nvarchar(max)
@IsMandatory optional bit
Default 1.
@CustomWhere optional nvarchar(max)
Custom where statement. May refer to these table aliases:
C = sys.columns
TY = sys.types