[Quantproject-developers] QuantProject/b2_DataAccess/Tables Bars.cs, 1.2, 1.3
Brought to you by:
glauco_1
Menu
▾
▴
[Quantproject-developers] QuantProject/b2_DataAccess/Tables Bars.cs, 1.2, 1.3
|
From: Glauco S. <gla...@us...> - 2008-11-18 22:57:06
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables In directory ddv4jf1.ch3.sourceforge.com:/tmp/cvs-serv9149/b2_DataAccess/Tables Modified Files: Bars.cs Log Message: bug fixed in sql string: barInterval is numeric (it was treated as a text field) Index: Bars.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Bars.cs,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** Bars.cs 14 Nov 2008 15:51:18 -0000 1.2 --- Bars.cs 18 Nov 2008 22:56:54 -0000 1.3 *************** *** 263,267 **** "bars." + Bars.TickerFieldName + "=tickers_tickerGroups." + Tickers_tickerGroups.Ticker + " " + "where " + Tickers_tickerGroups.GroupID + "='" + tickerOrGroupID + "' and " + ! Bars.IntervalFrameInSeconds + "='" + intervalFrameInSeconds + "' " + "and " + Bars.DateTimeForOpen + ">=" + SQLBuilder.GetDateTimeConstant( startDateTime ) + " " + "and " + Bars.DateTimeForOpen + "<=" + SQLBuilder.GetDateTimeConstant( endDateTime ) + " " + --- 263,267 ---- "bars." + Bars.TickerFieldName + "=tickers_tickerGroups." + Tickers_tickerGroups.Ticker + " " + "where " + Tickers_tickerGroups.GroupID + "='" + tickerOrGroupID + "' and " + ! Bars.IntervalFrameInSeconds + "=" + intervalFrameInSeconds + " " + "and " + Bars.DateTimeForOpen + ">=" + SQLBuilder.GetDateTimeConstant( startDateTime ) + " " + "and " + Bars.DateTimeForOpen + "<=" + SQLBuilder.GetDateTimeConstant( endDateTime ) + " " + *************** *** 270,274 **** sql = "select * from bars " + "where " + Bars.TickerFieldName + "='" + tickerOrGroupID + "' and " + ! Bars.IntervalFrameInSeconds + "='" + intervalFrameInSeconds + "' " + "and " + Bars.DateTimeForOpen + ">=" + SQLBuilder.GetDateTimeConstant( startDateTime ) + " " + "and " + Bars.DateTimeForOpen + "<=" + SQLBuilder.GetDateTimeConstant( endDateTime ) + " " + --- 270,274 ---- sql = "select * from bars " + "where " + Bars.TickerFieldName + "='" + tickerOrGroupID + "' and " + ! Bars.IntervalFrameInSeconds + "=" + intervalFrameInSeconds + " " + "and " + Bars.DateTimeForOpen + ">=" + SQLBuilder.GetDateTimeConstant( startDateTime ) + " " + "and " + Bars.DateTimeForOpen + "<=" + SQLBuilder.GetDateTimeConstant( endDateTime ) + " " + |
