Project Notes

Project: Basic resolving
Description
This sample application contains the completed files from the tutorial entitled Basic resolving in the Database Application Developer's Guide. It explores basic resolver functionality that extends the Querying a database (QueryProvide.jpr) tutorial. This application accesses the InterBase sample employee table and displays the data in a GridControl. You can make changes to the data displayed in the grid, then save the changes back to the employee table.

This tutorial requires that you have a version of JBuilder that includes the JBuilder DataBroker database architecture components.

Note: All versions of JBuilder provide direct access to SQL data through the JavaSoft JDBC API. Some versions of JBuilder provide additional DataBroker components (on the Data Access tab of the Component Palette) that greatly simplify RAD visual development of database applications. Refer to the JBuilder product page from the Borland Web site for availability of features in each JBuilder version.

Before you can run this application, install and set up Local InterBase Server and the sample data source as described in Installing and setting up in the Database Application Developer's Guide.

When you run this application, the GridControl displays the data from the sample employee table.

  • Use the keyboard, mouse, or navigator to scroll through the data displayed in the grid. The status bar updates as you navigate.
  • You can resize the window to display more or fewer fields, or scroll using the horizontal and vertical scrollbars.

Make changes to the data displayed in the grid by inserting, deleting, and updating data. You can save the changes back to the Local InterBase employee database choosing either,

  • the custom Save Changes button (created in the tutorial)
  • the Save button of the NavigatorControl

Note: Because of data constraints on the employee, the save operation may not succeed depending on the data you change. Since other edits may return errors, we suggest you make changes only to the FIRST_NAME and LAST_NAME values in existing rows until you become more familiar with the constraints on this table. For more information, see Installing Local InterBase Server and Tips on using InterBase in the Database Application Developer's Guide.