Tutorial Chapter 4: Query by Example

Implementing Query-by-Example
This program implements query-by-example, using the CONSTRUCT statement to allow the user to enter search criteria in a form. The criteria is used to build an SQL SELECT statement which will retrieve rows from the customer database table.

Allowing the User to Cancel the Query Operation
The query-by-example application demonstrates methods used to allow users to cancel an interactive dialog statement using predefined actions and conditional logic.

Retrieving data from the Database
When an SQL SELECT statement in your application will retrieve more than one row, a cursor must be used to pass the selected data to the program one row at a time.

Compiling and Linking the Program
The two example modules must be compiled and then linked into a single program. You can select the Build option in the Genero Studio Project view to perform these tasks or use command line tools.

Modifying the Program to Handle Errors
Topics in this section describe methods to detect and handle errors encountered during program execution.