TcxDBDataModeController.DetailInSQLMode Property

Determines whether the detail data controller is linked to a parameterized query dataset.

Declaration

property DetailInSQLMode: Boolean read; write; default False;

Property Value

Type	Default
Boolean	False

Remarks

Set the DetailInSQLMode property to True to indicate that the corresponding detail DataController is linked to a parameterized query dataset (query, for instance).

Parameters of a query must correspond to the detail key field names set using the DataController.DetailKeyFieldNames property.

When opening a specific detail, the query must be re-opened with the parameters set to values obtained from a corresponding master data controller record. This can be performed automatically for BDE and ADO queries if the parameter names are the same as the detail key field names (DataController.DetailKeyFieldNames). Note that you must add the cxADOAdapters unit to the uses section of your form if you want this to work for ADO queries.

The OnDetailFirst event allows you to set query parameters and re-open the query manually, but this is not a common practice. Refer to its description for more information.

Important

When in grid mode, detail data controllers cannot be linked to a parameterized query dataset, i.e. in this mode, the master data controller’s DetailInSQLMode property should be set to False.

The default value of the DetailInSQLMode property is False.