Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TcxDBDataModeController.DetailInSQLMode Property

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

#Declaration

Delphi
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.

See Also