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'" ...
Get Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
