version 2004
DBGateway_AddTextParameter (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 | Text | Text value to be substituted for the tag |
Description
The DBGateway_AddTextParameter command replaces a tag (tagIndex) with a Text (paramValue) that you can use from your SQL query instead of the value itself.
connID is a longint returned by DBGateway_Connect.
tagIndex is a String in the Select or Execute statement that will be replaced by paramValue at the time of execution.
paramValue is the Text value that will replace tagIndex at the time of execution.
Note that this call to DBGateway_AddTextParameter will also add quotes around the text and add SQL escape sequences for handling values with quotes.