SQLSetParamDate() function

The SQLSetParamDate() function sets the value of a parameter to a specified date.

Category

SQL

Syntax

SQLSetParamDate(StatementID, ParameterNumber, "Value");

Arguments

StatementID

Integer value that identifies a SQL statement within a query.

ParameterNumber

Integer value that identifies the parameter in the SQL statement identified by the StatementID argument.

Value

Date assigned to the parameter as a literal enclosed with double quotation marks or the name of a tag whose value is a date. The time assigned to the date is 12:00:00 AM.

Example

This example sets the second parameter of the third statement to the date associated with the NewDate tag.

SQLSetParamDate(3, 2, NewDate);

See Also

SQLPrepareStatement()