Adding buttons for relational database access: the DBNavigator bean

The DBNavigator bean gives you an easy way of adding to your program element a set of buttons that navigate the rows of a result set and perform various relational database operations.

tjgstdbn.gif (2482 bytes)

For example, one of the buttons makes the next row in the result set the current row, and another button commits changes to the database.

The DBNavigator bean is used in conjunction with a Select bean. As described above, the Select bean is used to retrieve a result set from a relational database. The DBNavigator bean operates on the result set.

To use the DBNavigator bean:

  1. Add the DBNavigator bean to the Visual Composition Editor surface.
  2. Edit DBNavigator bean properties. Among the properties that you edit are properties that specify which buttons will be displayed.
  3. Connect the DBNavigator bean to a Select bean.