SQLDisableSPForSelects

Examples


This setting creates stored procedures for completing single-record read operations at a SQL database. If you don't include this setting in the defaults file, no stored procedures will be created. Using auto-generated stored procedures at the SQL database will typically improve the performance of database read operations.

Syntax

SQLDisableSPForSelects=option

Parameters

option - A boolean indicating one of the following:

[spacer]

Value

Description

TRUE

Stored procedures won’t be created when a new table is created.

FALSE

Stored procedures will be created when the table is created. The database will use these stored procedures when completing single-record read operations.


Comments

If you add this setting and set it to FALSE, creating a new table in Dexterity will also create stored procedures for single-record reads at the SQL database. All existing tables will continue to complete single-record read operations without stored procedures.


Documentation Feedback