Analysts access financial data constantly. This homework will give you practice with (a) dynamic SQL queries, and (b) combo boxes.
SmallBankDB contains a table called StockMarket, which contains six months of closing prices for a basket of a dozen stocks. Create an app that
- Connects at startup with the database, and fills up two combo boxes with distinct dates and distinct tickers
- shows either all the available stocks for a given date at the press of a button, and
- shows all the available info for a given stock when a second button is pressed.
A vLab is provided. The vLab is a partial solution. Use the same listobject to show all the data, clearing it in between clicks.