DBGateway_AddLongIntParameter

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

version 2004


DBGateway_AddLongIntParameter (connID; tagIndex; paramValue)

ParameterTypeDescription
connIDLongintConnection ID returned by DBGateway_Connect
tagIndexStringTag which will be replaced in the SQL query
paramValueLongintLongint 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))

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