By default, the Params property is updated automatically to reflect any parameters that appear in the query specified by the CommandText property (or the SQL property for TSQLQuery) at runtime. That is, whenever the CommandText property changes, the Params property is regenerated to reflect the new set of parameters. 

There are times when you want to override this default behavior. For example, when specifying a data definition language (DDL) statement that defines a stored procedure, the resulting SQL command may include parameters. These parameters, however, should not be used as parameters of the SQL dataset, because they are not parameters of the DDL command, but rather, they are parameters of the stored procedure that the command creates. 

In order to override the default generation of the Params property in response to changes in CommandText, set ParamCheck to false. 

Params 

CommandText 

SQL