version 2004
DBGateway_AddDateParameter (connID; tagIndex; paramValue)
| Parameter | Type | Description | |
| connID | Longint | Connection ID returned by DBGateway_Connect | |
| tagIndex | String | Tag which will be replaced in the SQL query | |
| paramValue | Date | Date value to substituted for the tag |
Description
The DBGateway_AddDateParameter command replaces a tag (tagIndex) with a Date (paramValue) that you can use from your SQL query instead of the value itself.
connID is a Longint returned by DBGateway_Connect.
tagIndex s a String in the Select or Execute statement that will be replaced by paramValue at the time of execution.
paramValue is the Date value that will replace tagIndex at the time of execution.
Note that this call to DBGateway_AddDateParameter takes care of formatting your 4D Date value to a SQL Date value.