PATH  WebObjects 4.0 Documentation > EOF Tools and Techniques

Table of Contents Previous Section

Using Custom SQL and Stored Procedures

 Instead of building a qualifier for the fetch specification to fetch with, you can specify custom SQL or a stored procedure. To do so, use the SQL tab of the Fetch Specification Builder, as shown in Figure 47.

Figure 47. Using a Custom SQL Expression or a Stored Procedure

To use custom SQL, check the "Use Raw SQL Expression" box, and provide the SQL in the text field just below the box. If you've built a qualifier in the Qualifier Builder, this text field is initialized with the corresponding SQL. Checking the "Use Raw SQL Expression" box enables this text field so you can modify the text. Note that the Fetch Specification Builder isn't able to parse arbitrary SQL to produce a corresponding qualifier in the Qualifier Builder.

To use a stored procedure, check the "Use Stored Procedures" box, and choose the stored procedure from the list just below the box. The stored procedure must be defined in the model.

Table of Contents Next Section