Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server (Not)   Client   Old   Guides   Examples
New in version: 6.1   6.2   6.3   6.4   6.5   7.0   7.1   7.2   7.3   7.4    Statistic  

SQL.FetchLast

Fetches the last row from a result set.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
SQL 2.6 Yes Yes Yes Yes Yes

MBS( "SQL.FetchLast"; Command )

Parameters

Parameter Description Example value
Command The command reference number gained with SQL.NewCommand. $Command

Result

Returns 0, 1 or error message.

Description

Fetches the last 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 last record:

MBS("SQL.FetchLast"; $Command)

Requests a scrollable record set:

MBS( "SQL.SetCommandOption"; $Command; "Scrollable"; "True" )

See also


SQL.FetchFirst   -   SQL.FetchNext

Feedback: Report problem or ask question.




Links
MBS Xojo Plugins