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

SQL.GetRecordsAsText

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

Parameters

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.		 Optional
RowDelimiter The delimiter between records.
Default is newline character.		 Optional

Result

Returns text or error.

Description

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.

Warning: If the text contains the delimiters for fields and rows, you may get strange results. You can of course substitute these in the SQL query. See the REPLACE() function in SQL.

Examples

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]
Else
    Show Custom Dialog ["Inhalt"; MBS("SQL.GetRecordsAsText"; $command)]
End If
#Cleanup
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 15th December 2025


SQL.GetRecordsAsJSON - SQL.InsertOrUpdateRecords