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  

FM.SQL.Text

Queries text of SQL result.

Parameters

Parameter	Description	Example	Flags
SQLref	The reference number returned by FM.SQL.Execute function.	$SQLRef
firstRow	The index of first row. Default is 0.	0	Optional
lastRow	The index of last row. Default is FM.SQL.RowCount-1.	5	Optional
firstCol	The index of first column. Default is 0.	0	Optional
lastCol	The index of last column. Default is FM.SQL.FieldCount-1.	6	Optional
rowSeparator	The row separator. Default is CR.	Char(13)	Optional
colSeparator	The column separator. Default is tab character.	Char(9)	Optional

Result

Returns text or error.

Description

Examples

Query fields and export as text and CSV:

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 ) & " …"]
    # Write to text file
    Set Variable [$text; Value:MBS( "FM.SQL.Text"; $sql )]
    Set Variable [$desktopFolder; Value:MBS( "Folders.UserDesktop" )]
    Set Variable [$path; Value:MBS( "Path.AddPathComponent"; $desktopFolder; "fields.txt" )]
    Set Variable [$r; Value:MBS( "Text.WriteTextFile"; $text; $path; "UTF8")]
    # Write to text file
    Set Variable [$text; Value:MBS( "FM.SQL.CSV"; $sql )]
    Set Variable [$path; Value:MBS( "Path.AddPathComponent"; $desktopFolder; "fields.csv" )]
    Set Variable [$r; Value:MBS( "Text.WriteTextFile"; $text; $path; "UTF8")]
    # Cleanup
    Set Variable [$r; Value:MBS( "FM.SQL.Release"; $sql )]
End If

See also

• FM.SQL.CSV
• FM.SQL.Field
• FM.SQL.FieldCount
• FM.SQL.Min
• FM.SQL.Release
• FM.SQL.RowCount
• Folders.UserDesktop
• IsError
• Path.AddPathComponent
• SQL.FieldCount

Blog Entries

• FileMaker SQL with Sum, Min, Max and Avg on results
• CSV functions in MBS FileMaker Plugin
• MBS FileMaker Plugin, version 7.0pr2

FileMaker Magazin

• Ausgabe 3/2018, Seite 34, PDF

Release notes

• Version 7.0
  • Added FM.SQL.Text and FM.SQL.CSV.

Created 8th January 2017, last changed 8th January 2017

FM.SQL.Sum   -   FM.SQL.XMLRecord

Feedback: Report problem or ask question.