Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old


Queries all records as text.

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


Parameter Description Example Flags
Command The command reference number gained with SQL.NewCommand. $Command
FieldDelimiter The delimiter for between fields.
Default is a tab character.
RowDelimiter 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)]

Query with Let statement:

Let ( [
command = MBS("SQL.NewCommand"; 22001; "SELECT sqlite_version();");
status = MBS("SQL.Execute"; command);
result = MBS("SQL.GetRecordsAsText"; command);
freed = MBS("SQL.FreeCommand"; Command)
]; result)

See also

Blog Entries

This function is free to use.

Created 10th August 2015, last changed 23th September 2021

SQL.GetRecordsAsJSON - SQL.InsertOrUpdateRecords