[SCHEDULER-1260]  SQL Statement error on system with comma decimal separator
Type Bug
Priority High
Severity Major
Component Database Access Component
Fixed In Version [8.0] 8.0
Versions Affected [3.7] 3.7
Severity Closed
Resolution Complete
Reported By Bob Denny
Resources Bob Denny
Start Date 12/8/2014

Description 
Editing Plans fails under some conditions when the decimal separator is a comma.

Comments
12/8/2014 3:27:03 PM   Bob Denny 

 

  SVN Comment
 

 

  Author
  rbdenny
 

 

  Repository
  svn+ssh://rbdenny@a2_svn_dc3/home/rbdenny/svn/astro/scheduler
 

 

  SVN Revision
  471
 

 

  Affected files
  /trunk/Browser/BrowserForm.cs (Modified)
/trunk/Help/RelNotes.htm (Modified)

 

 

  Check-in comment
  Database export/import (XML) under InvariantCulture for systems with ',' as decimal point.
GEM:1260
12/8/2014 3:24:51 PM   Bob Denny 

 

  SVN Comment
 

 

  Author
  rbdenny
 

 

  Repository
  svn+ssh://rbdenny@a2_svn_dc3/home/rbdenny/svn/astro/scheduler
 

 

  SVN Revision
  470
 

 

  Affected files
  /trunk/Database/Database.cs (Modified)

 

 

  Check-in comment
  Make SQL statements and do XML export/import under InvariantCulture for systems with comma decimal point. NOW REQUIRES DATABASE 2.4 (GEM:342)
GEM:1260
12/8/2014 2:29:48 PM   Bob Denny 
Switch to InvariantCulture when generating SQL statements. Also do this when exporting and importing XML.