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.3   6.4   6.5   7.0   7.1   7.2   7.3   7.4   7.5   7.6    Statistic  

SQL.FetchNext

Fetches next 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.FetchNext"; 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 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

Example Databases


SQL.FetchLast   -   SQL.FetchPos

Feedback: Report problem or ask question.




Links
MBS Xojo Plugins