| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
SQL.SetParamAsDate
Sets parameter's value as Date data.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| SQL | 2.6 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "SQL.SetParamAsDate"; Command; Param; Value ) More
Parameters
| Parameter | Description | Example |
|---|---|---|
| Command | The command reference number gained with SQL.NewCommand. | $Command |
| Param | The parameter name or ID. Pass number for ID, a text with parameter name or the index with # prefix. e.g. "#0" for first parameter. | "1" |
| Value | The new value |
Result
Returns "OK" or error message.
Description
Sets parameter's value as Date data.Reports an error for invalid date. Version 8.0 and newer set parameter to NULL if you pass empty value.
Examples
Set parameter with ID 3 to a date value:
MBS("SQL.SetParamAsDate"; $Command; 3; $Birthday)
Set parameter with name "Date" to a date value:
MBS("SQL.SetParamAsDate"; $Command; "Date"; $Birthday)
See also
- SQL.GetParamAsDate
- SQL.GetParamAsPNG
- SQL.GetParamAsTime
- SQL.GetParamNameList
- SQL.GetParamValueList
- SQL.RowsAffected
- SQL.SetParamAsDateTime
- SQL.SetParamAsNumber
- SQL.SetParamAsText
- SQL.SetParamValue
Release notes
- Version 8.0
- Changed SQL.SetParamAsDateTime and SQL.SetParamAsDate to set param to NULL if you pass empty value.
Example Databases
Blog Entries
This function is free to use.
Created 18th August 2014, last changed 11st December 2017
