Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
9.3
9.4
9.5
10.0
10.1
10.2
10.3
10.4
10.5
10.6
Statistic
FMM
Blog
SQL.FetchNext
Fetches next row from a result set.
| Component | Version | macOS | Windows | Linux | Server | FileMaker iOS SDK |
| SQL | 2.6 | Yes | Yes | Yes | Yes | Yes |
Parameters
| Parameter | Description | Example |
|---|---|---|
| Command | The command reference number gained with SQL.NewCommand. | $Command |
Result
Returns 0, 1 or error message.
Description
Fetches next row from a result set.Use FetchNext method to fetch row by row from the result set. You need to call it a first time to get to first row after you made a query.
To check whether a result set exists use SQL.isResultSet method.
Result is 1 on success or 0 on failure.
Examples
Fetch next record:
MBS("SQL.FetchNext"; $Command)
Run command and fetch first record
// create command
$Command = MBS("SQL.NewCommand"; $Connection; "SELECT * FROM Test")
// run select
$result2 = MBS("SQL.Execute"; $Command)
// go to first row
$result3 = MBS("SQL.FetchNext"; $Command)
// result 3 is 1 if we got a record
// read first name field from result:
$firstname = MBS("SQL.GetFieldAsText"; $command; "FirstName")
// later release command
MBS("SQL.FreeCommand"; $Command)
Run a stored procedure:
# new command for calling our test procedure on a Microsoft SQL Server
Set Variable [$command; MBS( "SQL.NewCommand"; $Connection; "dbo.Test" ) ]
# set a parameter
Set Variable [$r; MBS( "SQL.SetParamAsNumber"; $Command; "Param1"; 7 ) ]
# execute query
Set Variable [$r; MBS( "SQL.Execute"; $Command ) ]
# fetch first record
Set Variable [$r; MBS( "SQL.FetchNext"; $Command ) ]
# get result field
Set Variable [$result; MBS( "SQL.GetFieldAsText"; $Command; 1 ) ]
See also
- SQL.Connect
- SQL.FreeCommand
- SQL.GetFieldNameList
- SQL.GetFieldsAsJSON
- SQL.GetFieldValueList
- SQL.GetRecordsAsText
- SQL.isResultSet
- SQL.NewCommand
- SQL.NewConnection
- SQL.SetParamAsNumber
Example Databases
- SQL to other databases/Firebird Query
- SQL to other databases/Microsoft Access Execute
- SQL to other databases/Microsoft SQL Execute
- SQL to other databases/Microsoft SQL Server Connect
- SQL to other databases/Microsoft SQL Server Query
- SQL to other databases/MySQL example
- SQL to other databases/MySQL Query
- SQL to other databases/ODBC Query
- SQL to other databases/SQLite blob
- SQL to other databases/SQLite fun
Blog Entries
FileMaker Magazin
Created 18th August 2014, last changed 24th April 2016
Feedback: Report problem or ask question.
Links
MBS FileMaker blog
