SoftadminGuide.FieldStandard_Column

Type: Stored procedure

Creates a standardized control to pick one column.

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 dropdown list, populated with all columns of the selected table.
    The @CustomWhere restricts the choise to columns of type varchar,
    beginning with 'A'.
*/
EXEC SoftadminGuide.FieldStandard_Column_Create
	@FieldName = 'ColumnField',
	@Label = 'Choose column',
	@TableFieldName = 'TableField',
	@CustomWhere = 'TY.name = ''varchar'' AND C.name LIKE ''A%''';