Go to Glossary Search VisualAge C++ Help Go to VisualAge C++ Help Home Page Go to WWW VisualAge C++ Site

Add/Modify SQL Predicate Notebook

The Add/Modify SQL Predicate notebook allows you to add or modify a user-defined method that is created using an SQL Predicate. The method is added to the generated <class>Manager. Methods defined in this notebook return a collection of rows from the schema. A live connection to the database is required so you can validate the SQL predicate.

The notebook has the following pages. Select a link to see details for the corresponding page:

Select the appropriate tab to move around the notebook. The following buttons appear at the bottom:

SQL Predicate Page
The SQL Predicate page lets you enter a name and an SQL predicate to define the method. It contains the following elements:

Parameter Page
The Parameter page lets you map method parameters (indicated by question marks in the SQL predicate) to C++ types. Each parameter is displayed in the Parameters container, and is modified by changing the fields below. Work with one parameter at a time by selecting one, making the desired changes, and clicking the Modify button when you are done; then, select the next parameter.

Use the following fields to modify the parameter mapping:

Click the Modify button when you are done with a parameter.

Comment Page
The Comment page lets you enter a comment for the user-defined method. The comment will be added to the generated code along with the method's C++ code.



User-Defined Methods


Data Access Class Library and Generated Code
Sample: Create and Use a User-Defined Method With SQL Predicate