[Quantproject-developers] QuantProject/b2_DataAccess DataBase.cs, 1.11, 1.12

[Glauco S. <gla...@us...>]

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess
In directory ddv4jf1.ch3.sourceforge.com:/tmp/cvs-serv30455/b2_DataAccess

Modified Files:
	DataBase.cs 
Log Message:
A bug has been fixed in the following method:

public static History GetBarOpenHistory(
			string ticker ,
			int barInterval ,
			DateTime firstDateTime ,
			DateTime lastDateTime ,
			List< Time > dailyTimes )

Index: DataBase.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/DataBase.cs,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** DataBase.cs	12 Nov 2008 20:36:28 -0000	1.11
--- DataBase.cs	20 Nov 2008 20:39:03 -0000	1.12
***************
*** 222,228 ****
  					SQLBuilder.GetFilterForTime(
  						"baDateTimeForOpen" , SqlComparisonOperator.Equal , time ) +
! 					" and ";
  			filterForDailyTimes = filterForDailyTimes.Substring(
! 				0 , filterForDailyTimes.Length - " and ".Length );
  			return filterForDailyTimes;
  		}
--- 222,228 ----
  					SQLBuilder.GetFilterForTime(
  						"baDateTimeForOpen" , SqlComparisonOperator.Equal , time ) +
! 					" or ";
  			filterForDailyTimes = filterForDailyTimes.Substring(
! 				0 , filterForDailyTimes.Length - " or ".Length );
  			return filterForDailyTimes;
  		}
***************
*** 238,242 ****
  		{
  			string sql =
! 				"select baOpen from bars " +
  				"where (baTicker='" + ticker + "') and " +
  				"(baInterval=" + barInterval + ") and" +
--- 238,243 ----
  		{
  			string sql =
! 				"select " + BarFieldNames.DateTimeForOpen + "," + BarFieldNames.Open +
! 				" from bars " +
  				"where (baTicker='" + ticker + "') and " +
  				"(baInterval=" + barInterval + ") and" +
***************
*** 245,250 ****
  				"(baDateTimeForOpen<=" +
  				SQLBuilder.GetDateTimeConstant( lastDateTime )
! 				+ ") and" +
! 				DataBase.getFilterForDailyTimes( dailyTimes );
  //			"(Format([baDateTimeForOpen],'hh:mm:ss')>='" +
  //				DataBase.getSqlTimeConstantForFirstDailyBar() + "') and" +
--- 246,252 ----
  				"(baDateTimeForOpen<=" +
  				SQLBuilder.GetDateTimeConstant( lastDateTime )
! 				+ ") and (" +
! 				DataBase.getFilterForDailyTimes( dailyTimes ) +
! 				")";
  //			"(Format([baDateTimeForOpen],'hh:mm:ss')>='" +
  //				DataBase.getSqlTimeConstantForFirstDailyBar() + "') and" +