That line is not there although the script date is 6/7/2010. Here is the stored procedure:
I was expecting the upgrade to change the file for me. I executed the update procedure after modifying it. It now works.
[DNNSpace] ANSI_NULLS ON QUOTED_IDENTIFIER ON PROCEDURE [dbo].[DNN_Smith_UpdateProductVariant]INT, @VariantGroup VARCHAR(50), @VariantName VARCHAR(50),@VariantDisplayType VARCHAR(50),
@VariantImage
BEGIN
Update
nvarchar(500), @PriceAdjustment Money, @WeightAdjustment FLOAT, @SortOrder INT, @PortalId INT, @VariantID INT, @VariantRequired bit AS DNN_Smith_ProductVariantSET ProductID = @ProductID,
VariantGroup
= @VariantGroup,
VariantName
= @VariantName,
VariantDisplayType
VariantImage
PriceAdjustment
= @VariantDisplayType, = @VariantImage, = @PriceAdjustment,
WeightAdjustment
= @WeightAdjustment,
SortOrder
= @SortOrder,
PortalId
= @PortalId,
VariantRequired
= @VariantRequiredWHERE VariantID = @VariantID
END
GO
USE
/****** Object: StoredProcedure [dbo].[DNN_Smith_UpdateProductVariant] Script Date: 06/07/2010 16:19:05 ******/
SET
GO
SET
GO
ALTER
@ProductID