Detailed Windows Framework

This framework handles the display of the lowest-level query, where each row of the tables of the database is displayed. Its features include:

1. Display the rows returned from a query.
2. Let the user edit the rows.
3. Before letting the user change the rows, pop up a dialog that asks the user to specify some information.
4. Search for a string in all the data, just specific columns.
5. Sort by a column.
6. Go to the nth row.

• DetailedTable displays the rows returned from a query. It actually has all the methods for row editing as well, but they are turned off by default. It does not query all the rows at once, but more rows are obtained as the scrollbar is pulled down. The user can specify the number of rows to return. The information that the detailed table uses is passed through a class called QueryDescription.
• The subclasses tend to be somewhat query specific. Each one assumes that certain fields exist in the query.
  • IncurrenceRatesTable is used for incurrence rates tables. It allows the rows to be edited.
  • SimpleErrorsTable, on the other hand, is more extensive because it not only edits the original table, but it also creates a row in the error table corresponding to the original table. It is assumed that the error table has at least all the fields of the original table.
  • DialogErrorsTable is even more extensive because it requires the user to enter some information which will be stored in the error table along with the original row information.
  • ErrorCorrectionTable does the reverse of DialogErrorsTable by displaying an error table, and when a row is edited, the error row is deleted, and the edited row is written to the non-error table. The error table's fields must have all of the fields of the non-error table.

• First the query descriptor is filled with relevant information. The detailed table used is DialogErrorsTable. The query is passed to it, as well as the fields that should not be shown in the detailed table. The query description, as well as the query used, must be passed to the table.

  	wrapper := CatModelWrapper models: (Array with: (detailed := DialogErrorsTable new)) windowLabel: 'Detailed Table'.
  	detailed
  		queryDescription: aQueryDescription;
  		baseQuery: query.
  
  	wrapper
  		state: state;
  		open
  

• CAT-ReportGraph

Return to Financial Model Documentation Page