IF NOT EXISTS (SELECT WidgetText FROM FormBuilderFormFields WHERE FormId = @formid AND WidgetText like @widgetText + '%')
		BEGIN
			INSERT INTO	FormBuilderFormFields (FormId, [Required], SortOrder, CreateDate, CreatedBy, WidgetId, WidgetText, WidgetVals, WidgetInputType)
					 VALUES (@formid, @required, @sortOrder, @createDate, @uid, @widgetId, @widgetText, @widgetVals, @widgetInputType)			
		END
	ELSE
		BEGIN
			UPDATE	FormBuilderFormFields SET
					[Required] = @required,
					SortOrder = @sortOrder,
					CreateDate = @createDate,
					CreatedBy = @uid,		
					WidgetId = @widgetId,
					WidgetText = @widgetText,
					WidgetVals = @widgetVals,
					WidgetInputType = @widgetInputType		
			WHERE	FieldId = (SELECT FieldId FROM FormBuilderFormFields WHERE WidgetText = (SELECT WidgetText FROM FormBuilderFormFields WHERE FormId = @formid AND WidgetText like @widgetText + '%'))-- AND FormId = @formid)
		END

quote:

---

Originally posted by MichaelJSQL

I am guessing that each widget on your forms have a specific text and id? if this is correct, you might have the UI pass in the form id and widget id along with the text value widget text. you could use a merge statement as well. If not even close, shed some more light by explaining a bit more information.

---

quote:

---

Originally posted by MichaelJSQL

I gather what you are saying is the widget id represents a control type and not a specific control on the form? Perhaps you might want to augment your design so each version of the control has its own unique ID unless that is what Field Id represents - in which case pass that and you won't need the like clause. or is there still more to this?

---