Modifying database query command properties

Use this procedure to set the command properties for database queries. You can set these properties at the level of all database queries or the level of an individual query or command.

You can modify these command properties:

  • Database Query Properties (DME)

    Property Description
    Disable IRowLocate Interface If True, the queries includes the row locate interface, which can make some queries running with Crystal Reports process more efficiently.
    PageSize Sets the number of records to receive at one time.
    Command Type

    Select Servlet or CGI, depending on whether you require the query to be processed using the servlet for the data query service or the DME CGI program.

    Options are: Default, Servlet, CGI.

    Release 9.0 and higher: All queries are to servlets.

    All Strings Controls whether all retrieved data is treated as strings. Use of this parameter may lead to a performance improvement, but only use if you are not required to maintain the data types of the data.
    One-To-Many Max Rows Sets the number of one-to-many records to receive at one time. The default is 25.
    One-To-Many Next Use this option in conjunction with the One To Many option if you want your output to include an additional column in the parent recordset for each child recordset. The additional columns contain the database command to retrieve the next set of child rows.
    One-To-Many Query type

    You have three options:

    • None: One to Many options are inactive by default. If you select None, options for One to Many Next and One-To-Many Max Rows do not apply.

    • Hierarchical: Select this option to use the hierarchical recordset feature. If you have specified a database query that generates one-to-many output, using this option gives you a hierarchical rowset where each row in the parent recordset has columns that represent child recordsets.

    • Flat: Select this option to use the flat recordset feature. A flat recordset does not distinguish between parent and child recordsets. Parent recordsets are repeated in a child recordset.

  • Active Command Properties (Database Query)

    Property Description
    Disable IRowLocate Interface If True, the active query includes the row locate interface, which can make some queries running with Crystal Reports process more efficiently.
    PageSize Sets the number of records to receive at one time for the current query.
    Command Type Select Servlet or CGI, depending on whether you want the query to be processed using the servlet for the data query service or the DME CGI program.
    All Strings Controls whether all retrieved data is treated as strings. Use of this parameter may lead to a performance improvement, but only use if you are not required to maintain the data types of the data.
    One-To-Many Max Rows Sets the number of one-to-many records to receive at one time for the current query. The default is 25.
    One-To-Many Next Use this option in conjunction with the One To Many option if you want your output to include an additional column in the parent recordset for each child recordset. The additional columns contain the database command to retrieve the next set of child rows.
    One-To-Many Query type

    You have three options:

    • None: One to Many options are inactive by default. If you select None, options for One to Many Next and One-To-Many Max Rows do not apply.

    • Hierarchical: Select this option to use the hierarchical recordset feature. If you have specified a database query that generates one-to-many output, using this option gives you a hierarchical rowset where each row in the parent recordset has columns that represent child recordsets.

    • Flat: Select this option to use the flat recordset feature. A flat recordset does not distinguish between parent and child recordsets. Parent recordsets are repeated in a child recordset.

To modify command properties

  1. Define the basic query.
  2. Right-click in the Properties view of the Query pane. (Click Properties if necessary to display the query properties.)
  3. Select Command Properties. The User Preferences windows appears.
  4. Click the plus sign for the level of command properties you want to modify.
  5. Right-click on the property you want to modify and select Edit Property Value.
  6. Select a value, or type a value and press Enter.

    If you are modifying the active command properties, the query string is modified to reflect your changes.

  7. Modify additional properties if you must.
  8. Close the User Preferences window.