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

SQLNext

Gets the next database record from an SQL query. Use the SQLExec() function to select a number of records or rows from the SQL database, and then use the SQLNext() function to step through each record separately.

Syntax

SQLNext(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

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

Related Functions

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

Example

See SQLConnect

See Also

SQL Functions