SoftadminGuide.FieldStandard_SqlObjectName

Type: Stored procedure

Creates a standardized control to select an sql table, view, procedure and/or function.

Expects a table #SoftadminGuideMultiControl created by SoftadminGuide.Field_MultiControl_Definition.

Example

/*
	This example is supposed to be part of a guide procedure,
	inside the "If @Action = 'GetFields'" block.
*/
	-- Create a textbox with autosearch, used to enter a procedure name.
	EXEC SoftadminGuide.FieldStandard_SqlObjectName
		@FieldName = 'ProcedureNameField',
		@Label = 'Select a procedure',
		@IsMandatory = 1,
		@AllowStoredProcedures = 1, -- Finds only procedures
		@AllowNonExisting = 1; -- Also accept a name that does not exist.

	-- In case the user entered a non-existing object,
	-- show a warning and demand the user confirm overwrite by checking a box.
	EXEC SoftadminGuide.FieldStandard_ExistingSqlObjectWarning
		@ObjectFieldName = 'ProcedureNameField', -- Same fieldname as above.
		@ConfirmOverwriteCheckBoxFieldName = 'OverwriteConfirmationCheckboxField',
		@AllowStoredProcedures = 1;