CreateSQLParameter(field, markerNumber)

Returns the SQLParameter object that is a parameter of SQL statement SELECT upon which the query has been built. The field argument specifies the query field (the Field object) on which the parameter is based. The integer argument markerNumber specifies the marker number in the SQL statement SELECT to which the parameter corresponds. The markers are numbered from 1, the step is 1, and the numbering is performed from the left to the right in the SQL statement. The initial value of the parameter created is Null. The created parameter is not added to the Query::SQLParameters collection. To use the created parameter in the query, add it to the Query::SQLParameters collection. You may set a parameter value (using the SQLParameter::Value property) both before adding and after adding to the Query::SQLParameters collection.