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

SQLNumChange

Gets the number of records that were modified in the last SQL Insert, Update, or Delete statement.

This function can be called in the foreground or background.

Syntax

SQLNumChange(hSQL)

hSQL:

The handle 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.

Return Value

The number of records that were modified. A value of 0 is returned if no fields were returned or if an error has occurred. (For details of an error code, call the SQLErrMsg function).

Related Functions

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

Example

See SQLBeginTran

See Also

SQL Functions

Published June 2018