SACommand::FetchPrior, SACommand::FetchFirst, SACommand::FetchLast

bool FetchPrior() throw (SAException);

Fetches previous row from a result set.

bool FetchFirst() throw (SAException);

Fetches the first row  from a result set.

bool FetchNext() throw (SAException);

Fetches the last row from a result set.

Return value

True if the row was fetched; otherwise false .

Remarks

Use FetchPrior, FetchFirst, FetchLast method to fetch rows from the scrollable result set. The scrollable result set option should be set before SACommand executed (SQLite and InterBase don't support this feature). See server specific notes to discover how SQLAPI++ supports the scrollable result set for cetain DBMS.

Each column of fetched row is represented by SAField object. If a result set exists after the last command execution, a set of SAField objects is created implicitly. To check whether a result set exists use isResultSet method. Each 'fetch' method updates value parts of SAField objects.

To get field description or value use Field method.

See also

isResultSet, Field, FieldCount

SAField 

Error handling

Problems and Questions

If you haven't found the answer to your questions or have some problems on using the Library, please, send e-mail to howto@sqlapi.com.