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.XMLRecord
Returns a row as XML object.
| Component | Version | macOS | Windows | Linux | Server | FileMaker iOS SDK |
| FM | 10.3 | Yes | Yes | Yes | Yes | Yes |
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| SQLref | The reference number returned by FM.SQL.Execute function. | $SQLRef | |
| RecordNodeName | The name for the parent XML nodes for ome record. Defaults to "record". |
"Company" | |
| Row | The row you like to get. | 1 | |
| FieldNames | A list of field names for the JSON. | "Model¶Names" | |
| Flags | The flags for the json creation. Pass 1 to get all values as text. Pass 2 to get all dates, times and timestamps in SQL format. |
1+2 | Optional |
Result
Returns OK or error.
Description
Returns a row as XML object.You provide list of field names, which should be in same order as fields in SQL result.
Optionally we can return SQL dates, times and timestamps as SQL format.
Containers are returned as Base64 encoded data.
Examples
Query records as XML:
# run query to get some data
Set Variable [ $sql ; Value: MBS( "FM.SQL.Execute"; ""; "SELECT \"First\", \"Last\", Company, \"Photo Container\" FROM Contacts") ]
# query data
Set Variable [ $xml ; Value: MBS( "FM.SQL.XMLRecord"; $sql; "person"; 0; "First¶Last¶Company¶Photo"; 2) ]
# store result
Set Field [ Contacts::Output ; $xml ]
# free memory
Set Variable [ $xml ; Value: MBS( "FM.SQL.Release"; $sql) ]
See also
Blog Entries
Created 29th June 2020, last changed 30th June 2020
FM.SQL.Text - FM.SQL.XMLRecords
Feedback: Report problem or ask question.
Links
MBS FileMaker Plugins
