CTI Client SQL functions (ActiveX)

SQLBegin

Start an SQL query.

Function SQLBegin(

String bstrCommand,

ULong dwCount,

ULongPtr pdwRequest

)

Parameters

bstrCommand

SQL command to send to the database

dwCount

Maximum number of records to query

pdwRequest

Query ID as return value

Remarks

The function starts a database query. Any SQL string can be passed in, so long as the administrator has not made any restrictions. Since a large number of records may be discovered, dwMaxCount should be used to limit the number. The query can be continued with SQLNext and ended with SQLEnd. Queries started with SQLBegin are terminated in the server automatically after a few minutes. A Query ID is returned from each query and is required in subsequent calls to SQLNext and SQLEnd. A return value of 0 means the query could not be initiated. This occurs when the user is not logged onto the database.

Example

SQL sample