[Quantproject-developers] QuantProject/b2_DataAccess/Tables Tickers.cs,1.3,1.4
Brought to you by:
glauco_1
|
From: Marco M. <mi...@us...> - 2005-01-20 19:13:42
|
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 '" + |