tomsen wrote:
Pls. have a look at the upgrade sql script 4.2 => 4.3:
--new column
IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShippingByWeightByTotalRecord]') and OBJECTPROPERTY(object_id, N'IsUserTable') = 1)
and NOT EXISTS (SELECT 1 FROM sys.columns WHERE object_id = object_id('[ShippingByWeightByTotalRecord]') AND NAME = 'TransitDays')
BEGIN
ALTER TABLE [ShippingByWeightByTotalRecord]
ADD TransitDays int NULL
END
GO
I added the transitdays with SSMS to keep the Shipping Plugin "working".
--new column
IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShippingByWeightByTotalRecord]') and OBJECTPROPERTY(object_id, N'IsUserTable') = 1)
and NOT EXISTS (SELECT 1 FROM sys.columns WHERE object_id = object_id('[ShippingByWeightByTotalRecord]') AND NAME = 'TransitDays')
BEGIN
ALTER TABLE [ShippingByWeightByTotalRecord]
ADD TransitDays int NULL
END
GO
I added the transitdays with SSMS to keep the Shipping Plugin "working".