Cicode Programming Reference > Cicode Function Categories > SQL Functions > SQLQueryDispose

SQLQueryDispose

The function disposes the query which handle is given as the argument.

Queries allocated by SQLQueryCreate should be disposed by SQLQueryDispose when no longer necessary. Each DB connection object has one default query which is created and disposed automatically. The default query need not be disposed by the function SQLQueryDispose.

This function can be called in the foreground or background.

Syntax

SQLQueryDispose(hQuery)

hQuery:

The handle to the query, returned from SQLQueryCreate() function.

Return Value

0 (zero) if successful, otherwise an error code is returned. (For details of the 307 error code, call the SQLErrMsg() function).

Related Functions

SQLSet, SQLAppend, SQLExec, SQLGetRecordset, SQLCall, SQLGetScalar, SQLEnd, SQLQueryCreate, SQLQueryDispose, SQLNumChange, SQLNoFields, SQLNumFields, SQLFieldInfo, SQLGetField, SQLIsNullField, SQLRowCount, SQLNext, SQLPrev

See Also

SQL Functions

Published June 2018