RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TAdoDbxCommand.Parameters Property
Pascal
property Parameters: DbParameterCollection;
C++
__property DbParameterCollection Parameters;

The parameters of the SQL statement or stored procedure. The default is an empty collection. 

You cannot use named parameters for passing parameters to a SQL Statement or a stored procedure called by a TAdoDbxCommand when CommandType is set to Text. In this case, the question mark (?) placeholder must be used. For example: SELECT * FROM Employee WHERE EmployeeID = ?. The order in which TAdoDbxParameter objects are added to the TAdoDbxParameterCollection must directly correspond to the position of the question mark placeholder for the parameter.  

If the parameters in the collection do not match the requirements of the query to be executed, you may get an error. 

 

Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!