MySQL_AddRealParameter

4D - Documentation   Français   English   German   4D For MySQL, Command Theme List   4D For MySQL, Command Alphabetical List   Back   Previous   Next

version 2004


MySQL_AddRealParameter (connID; key; paramValue)

ParameterTypeDescription
connIDLongintConnection ID returned by MySQL_Connect
keyStringString which will be replaced in the SQL query
paramValueRealReal value to be substituted for the key

Description

The MySQL_AddRealParameter command replaces a key with a Real (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 Real value that will replace key at the time of execution.

Example

   MySQL_AddRealParameter(connID;"%3";5.95)
   MySQL_Execute(connID,"INSERT INTO test(field1, field2, field3) VALUES (%1, %2, %3))

4D - Documentation   Français   English   German   4D For MySQL, Command Theme List   4D For MySQL, Command Alphabetical List   Back   Previous   Next