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