QueryProcedures

Defines whether all class queries project as SQL Stored Procedures.

Synopsis

[SQL]    QueryProcedures=n

Description

Defines whether or not all class queries project as SQL Stored Procedures regardless of the query's SqlProc setting. Default is 0. Only class queries defined with SqlProc=1 project as Stored Procedures. When set to 1, all class queries project as stored procedures. When changing this setting, you must recompile the classes with the class queries in order for this change to have an affect. Modifying this setting in the CPF file does not require a system restart to make it active.

Examples

QueryProcedures=1

Range of Values

0 or 1. The default is 0.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, in the All Class Queries Project as Stored Procedures setting, select Yes (to project queries as stored procedures) or No (the default).