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: 12.1   12.2   12.3   12.4   12.5   13.0   13.1   13.2   13.3   13.4    Statistic    FMM    Blog  

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.

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 23th September 2021


SQL.GetRecordsAsJSON - SQL.InsertOrUpdateRecords

💬 Ask a question or report a problem