SQLRowCount

Gets the number of rows in the recordset.

This function can be called in the foreground or background.

Syntax

SQLRowCount(hGeneral)

hGeneral:

The handle either to:

• the DB connection object, returned from either SQLCreate() or SQLConnect() function. The handle identifies the DB connection object where details of the associated SQL connection are stored
• the recordset

Return Value

The number of rows in the given recordset for disconnected recordsets. For the connected recordset, the function returns always -1.

Related Functions

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

Example

See SQLCreate.

See Also

SQL Functions

Published June 2018