[Quantproject-developers] QuantProject/b2_DataAccess/Tables Bars.cs, 1.9, 1.10

[Marco M. <mi...@us...>]

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

Modified Files:
	Bars.cs 
Log Message:
Some bugs have been fixed

Index: Bars.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Bars.cs,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** Bars.cs	8 Feb 2009 16:43:34 -0000	1.9
--- Bars.cs	13 Mar 2009 15:04:23 -0000	1.10
***************
*** 268,276 ****
  		                                      DateTime lastBarDateTime, int intervalFrameInSeconds)
  		{
! 			string sql = "select * from bars " +
  				"where " + Bars.TickerFieldName + "='" + ticker + "' and " +
  				Bars.IntervalFrameInSeconds + "='" + intervalFrameInSeconds + "' " +
! 				"and " + Bars.DateTimeForOpen + " between " + SQLBuilder.GetDateConstant(firstBarDateTime) + " " +
! 				"and " + SQLBuilder.GetDateConstant(lastBarDateTime) + " " +
  				"order by " + Bars.DateTimeForOpen;
  			return SqlExecutor.GetDataTable( sql );
--- 268,278 ----
  		                                      DateTime lastBarDateTime, int intervalFrameInSeconds)
  		{
! 			string sql = "select " + 
! 				Bars.Open + "," + Bars.Low + "," + Bars.High + "," + Bars.Close +   
! 				" from bars " +
  				"where " + Bars.TickerFieldName + "='" + ticker + "' and " +
  				Bars.IntervalFrameInSeconds + "='" + intervalFrameInSeconds + "' " +
! 				"and " + Bars.DateTimeForOpen + " between " + SQLBuilder.GetDateTimeConstant(firstBarDateTime) + " " +
! 				"and " + SQLBuilder.GetDateTimeConstant(lastBarDateTime) + " " +
  				"order by " + Bars.DateTimeForOpen;
  			return SqlExecutor.GetDataTable( sql );
***************
*** 382,386 ****
  		{
  			string sql =
! 				"select baDateTimeForOpen from bars " +
  				"where (baTicker='" + ticker + "') and " +
  				"(baInterval=" + intervalFrameInSeconds + ") and" +
--- 384,388 ----
  		{
  			string sql =
! 				"select baDateTimeForOpen, baOpen, baHigh, baLow, baClose from bars " +
  				"where (baTicker='" + ticker + "') and " +
  				"(baInterval=" + intervalFrameInSeconds + ") and" +