| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
FM.SQL.RowCount
Queries number of rows in the result.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| FM FMSQL | 5.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "FM.SQL.RowCount"; SQLref ) More
Parameters
| Parameter | Description | Example |
|---|---|---|
| SQLref | The reference number returned by FM.SQL.Execute function. | $SQLRef |
Result
Returns number or error.
Description
Queries number of rows in the result.Examples
Query some values:
Set Variable [$sql; Value:MBS( "FM.SQL.Execute"; ""; "select * from Clients")]
If [MBS("IsError")]
Show Custom Dialog ["SQL error"; $sql]
Else
Show Custom Dialog ["SQL result"; "got " & MBS( "FM.SQL.RowCount"; $sql ) &" rows with each " & MBS( "FM.SQL.FieldCount"; $sql ) & " …"]
Set Variable [$r; Value:MBS( "FM.SQL.Release"; $sql )]
End If
See also
- FM.SQL.FieldType
- FM.SQL.InsertRecords
- FM.SQL.JSONRecords
- FM.SQL.Min
- FM.SQL.Sum
- FM.SQL.Text
- FM.SQL.XMLRecords
- Matrix.JSONRecords
- SQL.Execute
- SQL.FieldCount
Example Databases
- DynaPDF/Extract Images
- SQL in FileMaker/ImageGallery
- SQL in FileMaker/SQL Select Container
- SQL to other databases/SQL Export
Blog Entries
- Sending email with a huge custom function
- FileMaker records to XML or JSON
- Image Gallery in FileMaker using SQL
- Execute SQL in FileMaker and get back native field types
FileMaker Magazin
This function is free to use.
Created 18th April 2015, last changed 8th January 2017
