NewEdit

-----------------------
-- Begin transaction --
-----------------------

DECLARE
	@IsUsingLocalTransaction	bit

IF @@TRANCOUNT = 0
BEGIN
	SET XACT_ABORT ON
	BEGIN TRANSACTION

	SELECT
		@IsUsingLocalTransaction = 1
END

--------------------------
-- INSERT/UPDATE/DELETE --
--------------------------

<DML statements>

------------------------
-- Commit transaction --
------------------------

IF @IsUsingLocalTransaction = 1
BEGIN
	COMMIT TRANSACTION
END

ALTER PROCEDURE Example.NewEdit_DynamicFieldInfoGetEditFields
AS
BEGIN

	-----------------------
	-- Fields to NewEdit --
	-----------------------

	SELECT
		-- In this example, this field keeps its original field info
		CONVERT(varchar(1000), NULL) AS [ExampleFieldChangedByDynamicFieldInfo1],
		-- And these fields will have their field changed by dynamic field info
		CONVERT(varchar(1000), NULL) AS [ExampleFieldChangedByDynamicFieldInfo2],
		CONVERT(varchar(1000), NULL) AS [ExampleFieldChangedByDynamicFieldInfo3],
		CONVERT(varchar(1000), NULL) AS [ExampleFieldChangedByDynamicFieldInfo4]

	------------------------
	-- Dynamic field info --
	------------------------

	/*
		You don't have to SELECT all dynamic field info in one result set,
		the presence of the column [ADMINFieldName] in the result sets tells
		Softadmin® that the result set specifies dynamic field info.

		The basic structure is to specify the field to change in a column [ADMINFieldName],
		the other columns are the properties to be changed. NULL values are
		interpreted as keeping the static field info.
	*/
	
	SELECT
		-- Field to change
		'ExampleFieldChangedByDynamicFieldInfo2' AS [ADMINFieldName],
		-- Properties to change
		'Look how I''ve changed the label but not the description' AS [FieldLabel],
		NULL AS [Description]	-- NULL value, original description will be used

	SELECT
		-- Field to change
		 'ExampleFieldChangedByDynamicFieldInfo3' AS [ADMINFieldName],
		-- Properties to change
		 'Look how I''ve changed the description, width and height' AS [Description],
		 400 AS [Width],
		 225 AS [Height]

	SELECT
		-- Field to change
		 'ExampleFieldChangedByDynamicFieldInfo4' AS [ADMINFieldName],
		-- Properties to change
		 'Look how I''ve changed the label, type and default value' AS [FieldLabel],
		 'Uneditable text' AS [FieldType],
		 '* Try and change me if you can *' AS [DefaultValue]

END

CREATE TABLE #ToPostProcess
(
	ThingyId int not null
);

 /* Choose things to post-process here */
INSERT #ToPostProcess (ThingyId)
SELECT n
FROM SoftadminUtil.Number_Range(1,5);

EXEC SoftadminApi.Progress_SetTitle
	@TitleText = 'Post processing thingies';

DECLARE
	@CompletedSteps int = 0,
	@TotalSteps int = (SELECT COUNT(*) FROM #ToPostProcess);

DECLARE ThingyCursor CURSOR LOCAL FOR
SELECT
	ThingyId
FROM
	#ToPostProcess;

OPEN ThingyCursor;
WHILE 1=1
BEGIN
	EXEC SoftadminApi.Progress_SetStep
		@CompletedSteps = @CompletedSteps,
		@TotalSteps     = @TotalSteps;

	DECLARE @ThingyId int;
	FETCH ThingyCursor INTO @ThingyId;

	IF @@FETCH_STATUS <> 0
		BREAK;

	/* Post-process Thingy with id @ThingyId here */
	-- EXEC Example.Thingy_PostProcess @ThingyId = @ThingyId;

	SET @CompletedSteps += 1;
END
CLOSE ThingyCursor;
DEALLOCATE ThingyCursor;

DROP TABLE #ToPostProcess;