[Quantproject-developers] QuantProject/b2_DataAccess/Tables Tickers.cs,1.3,1.4

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

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

Modified Files:
	Tickers.cs 
Log Message:
Updated method for getting tickers for the TickerViewer form


Index: Tickers.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Tickers.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** Tickers.cs	1 Dec 2004 22:47:00 -0000	1.3
--- Tickers.cs	20 Jan 2005 19:13:33 -0000	1.4
***************
*** 107,111 ****
        if(firstQuoteDate.CompareTo(lastQuoteDate)>0)
          throw new Exception("Last Date can't be previous of First date!");
!       sqlSelectString = "SELECT tiTicker, tiCompanyName, Min(quotes.quDate) AS FirstQuote, Max(quotes.quDate) AS LastQuote " +
        "FROM quotes INNER JOIN tickers ON quotes.quTicker = tickers.tiTicker " +
        "WHERE tiTicker LIKE '" +
--- 107,112 ----
        if(firstQuoteDate.CompareTo(lastQuoteDate)>0)
          throw new Exception("Last Date can't be previous of First date!");
!       sqlSelectString = "SELECT tiTicker, tiCompanyName, " + 
!       "Min(quotes.quDate) AS FirstQuote, Max(quotes.quDate) AS LastQuote, Count(quotes.quDate) AS NumberOfQuotes " +
        "FROM quotes INNER JOIN tickers ON quotes.quTicker = tickers.tiTicker " +
        "WHERE tiTicker LIKE '" +