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


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




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


See SQLBeginTran

See Also

SQL Functions