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

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

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31005/b2_DataAccess/Tables

Modified Files:
	Quotes.cs 
Log Message:
Added the order by clause to the select statement

Index: Quotes.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Quotes.cs,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** Quotes.cs	19 Jun 2004 01:07:32 -0000	1.11
--- Quotes.cs	25 Jun 2004 14:12:23 -0000	1.12
***************
*** 498,503 ****
  				"select * from quotes " +
  				"where " + Quotes.TickerFieldName + "='" + ticker + "' " +
!         "and " + Quotes.Date + ">=" + SQLBuilder.GetDateConstant( startDate ) +
!         "and " + Quotes.Date + "<=" + SQLBuilder.GetDateConstant( endDate );
  			SqlExecutor.SetDataTable( sql , dataTable );
  		}
--- 498,504 ----
  				"select * from quotes " +
  				"where " + Quotes.TickerFieldName + "='" + ticker + "' " +
!         "and " + Quotes.Date + ">=" + SQLBuilder.GetDateConstant( startDate ) + " " +
!         "and " + Quotes.Date + "<=" + SQLBuilder.GetDateConstant( endDate ) + " " +
! 				"order by " + Quotes.Date;
  			SqlExecutor.SetDataTable( sql , dataTable );
  		}