version 2004
MySQL_AddLongintParameter (connID; key; paramValue)
| Parameter | Type | Description | |
| connID | Longint | Connection ID returned by MySQL_Connect | |
| key | String | String which will be replaced in the SQL query | |
| paramValue | Longint | Longint value to be substituted for the key |
Description
The MySQL_AddLongintParameter command replaces a key with a Longint (paramValue) that you can use from your SQL query instead of the value itself.
connID is a Longint returned by MySQL_Connect.
key 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 key at the time of execution.
Example
MySQL_AddLongintParameter(connID;"%1";128225) MySQL_Execute(connID,"INSERT INTO test(field1, field2, field3) VALUES (%1, %2, %3))