version 2004
DBGateway_AddIntegerParameter (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 | Integer | Integer value to substituted for the tag |
Description
The DBGateway_AddIntegerParameter command replaces a tag (tagIndex) with an Integer (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 Integer value that will replace the tagIndex at the time of execution.
Example
DBGateway_AddIntegerParameter(connID;"%2";5) DBGateway_Execute(connID,"INSERT INTO test(field1, field2, field3) VALUES (%1, %2, %3))