Components | All | New | MacOS | Windows | Linux | iOS | ||||
Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old |
SQL.FetchPrior
Fetches previous row from a result set.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
SQL | 2.6 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "SQL.FetchPrior"; Command ) More
Parameters
Parameter | Description | Example |
---|---|---|
Command | The command reference number gained with SQL.NewCommand. | $Command |
Result
Returns 0, 1 or error message.
Description
Fetches previous row from a result set.Use SQL.FetchPrior, SQL.FetchFirst, SQL.FetchLast method to fetch rows from the scrollable result set. The scrollable result set option should be set before Command 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.
To check whether a result set exists use SQL.isResultSet method.
Scrolling only works if enabled, so please call SQL.SetCommandOption function to enable it if needed.
Result is 1 on success or 0 on failure.
Examples
Fetch previous record:
MBS("SQL.FetchPrior"; $Command)
Requests a scrollable record set:
MBS( "SQL.SetCommandOption"; $Command; "Scrollable"; "True" )
See also
This function is free to use.
Created 18th August 2014, last changed 24th April 2016