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

TdxServerModeDataSourceOptions.UseQueryParams Property

Controls if the SQL adapter generates queries with parameters.

#Declaration

Delphi
property UseQueryParams: Boolean read; write; default True;

#Property Value

Type Default
Boolean True

#Remarks

Normally, parameterized queries allow you to improve performance due to the intrinsic server optimizations provided for them. Set the UseQueryParams property to False to prohibit the SQL adapter from generating parameterized queries.

Note

Parameterized queries are not used regardless of the UseQueryParams property value if the TdxServerModeDBXDataSource or TdxServerModeDBXQueryDataSource data source is used in Delphi 7, Delphi 2007, or C++Builder 2007. In addition, parameters are not created for date-time values when the server mode data source is connected to a Microsoft Access, Advantage, Oracle, or PostgreSQL database and uses date/time grouping options.

The default value of the UseQueryParams property is True.

See Also