Homework 10

Dynamic queries to access remote data

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.