TdxServerModeDataSourceOptions.UseQueryParams Property

Controls if the SQL adapter generates queries with parameters.

Declaration

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.