| True DataControl 8.0 Reference > Parameter Object > Parameter Object Properties > SQLParameter Property |
SQLParameter Property
Sets/returns the name of an SQL parameter associated with this parameter.
Parameter.SQLParameter = string
Read/Write at run time and design time. Property applies to Parameter object. Not available in True DataControl Lite.
This property allows you to connect a True DataControl parameter (a Parameter object) to a parameter in an SQL statement that is used as the RecordSource of the TData control.
If this property is left empty, the Parameter object is unrelated to SQL parameters.
If this property is set to a non-empty string, this parameter will be associated with an SQL parameter. The association is performed based on the parameters’ ordinal positions in the Parameters collection and in the SQL statement. TData control parameters with an empty SQLParameter property do not participate in the association.
The above rule implies that the actual string assigned to the SQLParameter property is not important. What important is the fact that SQLParameter is non-empty, and the index of the parameter in the Parameters collection. However, it is reasonable to always set SQLParameter to the corresponding SQL parameter name, if SQL parameters are named.
See Parameterized SQL for details.
See Also