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

SQLNumChange

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

Syntax

SQLNumChange(hSQL)

hSQL:

The handle to the SQL connection, returned from the SQLConnect() function. The SQL connection handle identifies the table 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, call the SQLErrMsg function).

Related Functions

SQLBeginTran, SQLCommit, SQLConnect, SQLDisconnect, SQLEnd, SQLErrMsg, SQLExec, SQLFieldInfo, SQLGetField, SQLInfo, SQLNext, SQLNoFields, SQLRollBack, SQLTraceOff, SQLTraceOn

Example

See SQLBeginTran

See Also

SQL Functions