Post
by Hendrik_Ambrosius » 25. Jun 2012, 15:07
Das ist ein Bug. Lassen Sie folgendes SQL-Script gegen die EmpLocations-DB laufen:
-- Sets Service module amount
BEGIN
DECLARE @Option VARCHAR(40) = 'EMP_MODULES', @NewValue VARCHAR(1) = '7', @OldValue VARCHAR(255)
SELECT @OldValue = EmpValue FROM Options WHERE EmpOption = @Option
IF @OldValue IS NULL
INSERT INTO Options(EmpOption, EmpValue, UserID) VALUES (@Option, @NewValue, 0)
ELSE
UPDATE Options SET EmpValue = @NewValue, UserID = 0 WHERE EmpOption = @Option
END;
Hendrik Ambrosius / Senior Presales Consultant
Mobile: +49 172 408 4447 | hendrik.ambrosius@matrix42.com
Matrix42 GmbH | Elbinger Straße 7 | 60487 Frankfurt am Main | Germany | www.matrix42.com
Disclaimer: I participate in this forum on a voluntary basis. Views expressed are not necessarily those of Matrix42 or of the support team.