Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 8.0   8.1   8.2   8.3   8.4   8.5   9.0   9.1   9.2   9.3    Statistic  


Queries all records as text.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
SQL 5.3 Yes Yes Yes Yes Yes
MBS( "SQL.GetRecordsAsText"; Command { ; FieldDelimiter; RowDelimiter } )   More


Parameter Description Example value
Command The command reference number gained with SQL.NewCommand. $Command
FieldDelimiter Optional
The delimiter for between fields. Default is a tab character.
RowDelimiter Optional
The delimiter between records. Default is newline character.


Returns text or error.


Queries all records as text.
Don't call SQL.FetchNext before as this function will call it for you to loop over records.
Converts all field content to text.
If you just want one field, maybe you just select the required field with your select statement.


Run and query result as text:

#Create select and run it
Set Variable [$Command; Value:MBS("SQL.NewCommand"; $Connection; "SELECT * FROM Test")]
#Run it
Set Variable [$result; Value:MBS("SQL.Execute"; $Command)]
If [$result ≠ "OK"]
    Show Custom Dialog ["Error: " & $result]
    Show Custom Dialog ["Inhalt"; MBS("SQL.GetRecordsAsText"; $command)]
End If
Set Variable [$result2; Value:MBS("SQL.FreeCommand"; $Command)]

See also

Blog Entries

Created 10th August 2015, last changed 11st August 2015

SQL.GetParamValueList   -   SQL.InsertOrUpdateRecords

Feedback: Report problem or ask question.

MBS Xojo Plugins