AnyDAC
ContentsIndexHome
PreviousUpNext
TADResourceOptions.ParamExpand Property

Controls expansion of parameters.

Group
Links

Use ParamExpand property to control parameters expansion. If it is True, then the AnyDAC styled markers (:name) will be replaced with the DBMS SQL dialect markers. If it is False, then AnyDAC does not replace the parameter markers. The default value is True. 

Setting ParamExpand to False, may be usefull if:

  • SQL command cannot contain parameters, like a DDL SQL. But a command may contain AnyDAC-like markers, which actually are not the parameters. In some cases such markers may confuse AnyDAC.
  • application does not use parameters at all.

Setting PreprocessCmdText to False, sets ParamsExpand to False.

property ParamExpand: Boolean;
What do you think about this topic? Send feedback!