SQLPrev

Gets the previous database record from an SQL query. The function works only with disconnected recordsets. Use the SQLGetRecordset() function to select a number of records or rows from the SQL database, and then use the SQLNext()/SQLPrev() function to step through each record separately.

This function can be called in the foreground (only for disconnected recordsets) or background.

Syntax

SQLPrev(hGeneral)

hGeneral:

The handle to the disconnected recordset.

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

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

Example

See SQLConnect

See Also

SQL Functions