Changeset 1104 for Scheduling/trunk/cs/bsdx0200GUISourceCode

Timestamp:

Mar 7, 2011, 5:59:47 AM (15 years ago)

Author:

Sam Habiel

Message:

CGDocumentManager: Holiday SQL statement relied on Windows Date which is culture specific. Now sent as culture insensitive FM Date for query.

File:

• Scheduling/trunk/cs/bsdx0200GUISourceCode/CGDocumentManager.cs (modified) (1 diff)

Scheduling/trunk/cs/bsdx0200GUISourceCode/CGDocumentManager.cs

@@ -678 +678 @@
             setProgressDelegate(15);
             setStatusDelegate(statusConst + " Holiday");
-            sCommandText = "SELECT NAME, DATE FROM HOLIDAY WHERE DATE > '" + DateTime.Today.ToShortDateString() + "'";
+            sCommandText = "SELECT NAME, DATE FROM HOLIDAY WHERE INTERNAL[DATE] > '" + FMDateTime.Create(DateTime.Today).DateOnly.FMDateString + "'";
             ConnectInfo.RPMSDataTable(sCommandText, "HOLIDAY", m_dsGlobal);
             Debug.Write("LoadingGlobalRecordsets -- Holidays loaded\n");