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.FetchPos
Fetches a row from a result set.
| Component | Version | macOS | Windows | Linux | Server | FileMaker iOS SDK |
| SQL | 5.1 | Yes | Yes | Yes | Yes | Yes |
MBS( "SQL.FetchPos"; Command; Offset { ; Relative } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| Command | The command reference number gained with SQL.NewCommand. | $Command | |
| Offset | The index/offset of the row. Zero based. | 1 | |
| Relative | Pass 1 for relative movement. | 0 | Optional |
Result
Returns 0, 1 or error message.
Description
Fetches a row from a result set.You may need to request recordset to be scrollable to have this work. For that, please call MBS( "SQL.SetCommandOption"; $Command; "Scrollable"; "True" ) before doing the query.
Result is 1 on success or 0 on failure.
See also
Created 6th May 2015, last changed 24th April 2016
SQL.FetchNext - SQL.FetchPrior
Feedback: Report problem or ask question.
Links
MBS FileMaker Plugins
