Displaying and Navigating the Result Set

You can display data in the result set by making a property-to-property connection between the appropriate source property of the Select bean and an appropriate target property of an interface component such as a text field. The Select bean has two bound properties for each data column in the SQL specification. One property is the data column in its specified data type, another is a String representation of the data column. So, for example, you can make a property-to-property connection between the String representation of a data column in the result set and the text property of a text field. When you make the connection, code is generated to invoke the getColumnValue method; the method gets the column value.

Many of the Select bean methods are designed to operate on the current row of the result set. When an SQL statement is executed using a Select bean, the first row of the result set is the current row. If a column value of the result set is connected to an interface component such as a text field, the column value in the current row is displayed in the text field.

You can navigate the result set by using the DBNavigator bean. Using the DBNavigator bean, you can:

When the current row changes, the values of the bound column properties also change to reflect the values of the new current row. Navigating through the result set changes the value of the data displayed in any interface component connected to the Select bean.
Related concepts
About Relational Database Access

Related procedures
Editing Select Bean Properties
Adding the DBNavigator Bean to the Visual Composition Editor Surface
Connecting Beans

Related references
Select
DBNavigator