catch up with development Signed-off-by: Ralf Mollik <ramollik@compex-commerce.com>
diff --git a/org.eclipse.osbp.preferences.ui.page/src/org/eclipse/osbp/preferences/ui/page/PreferencePageBI.java b/org.eclipse.osbp.preferences.ui.page/src/org/eclipse/osbp/preferences/ui/page/PreferencePageBI.java new file mode 100644 index 0000000..c815cbd --- /dev/null +++ b/org.eclipse.osbp.preferences.ui.page/src/org/eclipse/osbp/preferences/ui/page/PreferencePageBI.java
@@ -0,0 +1,37 @@ +/** + * + * Copyright (c) 2011, 2016 - Loetz GmbH&Co.KG (69115 Heidelberg, Germany) + * + * All rights reserved. This program and the accompanying materials + * are made available under the terms of the Eclipse Public License 2.0 + * which accompanies this distribution, and is available at + * https://www.eclipse.org/legal/epl-2.0/ + * + * SPDX-License-Identifier: EPL-2.0 + * + * Contributors: + * Christophe Loetz (Loetz GmbH&Co.KG) - initial implementation + */ +package org.eclipse.osbp.preferences.ui.page; + +import org.eclipse.osbp.preferences.Preference; +import org.eclipse.osbp.preferences.ui.component.APreferencePage; +import org.eclipse.osbp.preferences.ui.component.Item; +import org.eclipse.osbp.preferences.ui.component.Type; + +public class PreferencePageBI extends APreferencePage { + + public PreferencePageBI() { + super( + "BI", + "Configuration for business intelligence intergration" + ); + } + + @Override + protected Item[] initializeItems() { + return new Item[] { + new Item(Type.TEXT, Preference.CUBE_VIEW_PORT, "Cube view port", false), + }; + } +}
diff --git a/org.eclipse.osbp.preferences/src/org/eclipse/osbp/preferences/databases/vendors/MSSQLDatabaseVendor.java b/org.eclipse.osbp.preferences/src/org/eclipse/osbp/preferences/databases/vendors/MSSQLDatabaseVendor.java index 97f49ac..5182e53 100644 --- a/org.eclipse.osbp.preferences/src/org/eclipse/osbp/preferences/databases/vendors/MSSQLDatabaseVendor.java +++ b/org.eclipse.osbp.preferences/src/org/eclipse/osbp/preferences/databases/vendors/MSSQLDatabaseVendor.java
@@ -166,12 +166,12 @@ @Override public String convertToDateSQL(Date date) { - return "cast('" + date.toString().replace(".0", "") + "' as datetime)"; + return "convert(datetime, '" + date.toString().replace(".0", "") + "', 121)"; } @Override public String convertToTimestampSQL(Timestamp date) { - return "cast('" + date.toString().replace(".0", "") + "' as datetime2)"; + return "convert(datetime2, '" + date.toString().replace(".0", "") + "', 121)"; } /**