O'Reilly logo

Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ by Dan Scott, George Baklarz, Paul C. Zikopoulos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

View Transaction Log

The transaction log contains records for each ticket that has been purchased. The transaction log can be displayed if you want to see what purchases were made at the theater, or if you need to refund a ticket (see Figure 12-17).

Figure 12-17. Transaction log

The ymldTransactions panel populates this screen with data using a DataGrid control and a data set. The logic is identical to that used in the ymldProductions panel. The application issues a SELECT statement against the TRANSACTIONS table and displays the result.

 Dim TXS As New DataTable() Dim mySelectQuery As String = _ "SELECT * FROM TRANSACTIONS WHERE TX_TYPE='PURCHASE'" ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required