SQL.isResultSet
---------------

Tests whether a result set exists after the command execution.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [SQL](component_SQL.md) | [2.6](newinversion26.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "SQL.isResultSet"; Command ) 

**MBS**( **"SQL.isResultSet";** /\* Tests whether a result set exists after the command execution. \*/  
**$Command**) /\* The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| Command | The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). | $Command |

### Result

Returns 1 if the result set exists; otherwise 0.

### Description

Tests whether a result set exists after the command execution.  
### Examples

Check result status:

 Set Variable \[$r ; Value:MBS ( "SQL.isResultSet"; $Command )\]  
### See also

- [SQL.Execute](SQLExecute.md)
- [SQL.FetchFirst](SQLFetchFirst.md)
- [SQL.FetchLast](SQLFetchLast.md)
- [SQL.FetchNext](SQLFetchNext.md)
- [SQL.FetchPrior](SQLFetchPrior.md)
- [SQL.NewCommand](SQLNewCommand.md)

### FileMaker Magazin

- [Ausgabe 4/2016, Seite 28](https://filemaker-magazin.de/neuigkeit/3876-Appetithappen-FMM_201604)
- [Ausgabe 3/2016, Seite 30](https://filemaker-magazin.de/neuigkeit/3883-Appetithappen-FMM_201603)
- [Ausgabe 2/2016, Seite 14](https://filemaker-magazin.de/neuigkeit/3879-Appetithappen-FMM_201602)
- [Ausgabe 1/2016, Seite 29](https://filemaker-magazin.de/neuigkeit/3870-Appetithappen-FMM_201601)

This function is free to use.

Created 18th August 2014 , last changed 10th January 2017

  
[SQL.isOpened](SQLisOpened.md) - [SSH.CloseChannel](SSHCloseChannel.md)

[HTML Version](SQLisResultSet.shtml)