| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
XML.Import.SetExtraField
Sets the extra field to add to all tables.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| XML | 7.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "XML.Import.SetExtraField"; FieldName; FieldValue { ; FieldType } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| FieldName | The name of the extra field. | "ImportID" | |
| FieldValue | The value for this field. Can be any data type, but must match field type. |
1 | |
| FieldType | The SQL field type. Default is "VARCHAR" for a text field. |
"VARCHAR" | Optional |
Result
Returns OK or error.
Description
Sets the extra field to add to all tables.Please call before XML.Import.
You can call it again when import loop is done and pass in empty name and value to clear it.
Only one extra field and only added when table is created.
Examples
Set extra field:
Set Variable [ $r ; Value: MBS( "XML.Import.SetExtraField"; "test"; "Hello"; "VARCHAR") ]
See also
- JSON.Import
- JSON.Import.SetExtraField
- XML.Import
- XML.Import.SetBaseFields
- XML.Import.SetExtraFieldDefinitions
Release notes
- Version 13.5
- Added XML.Import.GetExtraFieldDefinitions and XML.Import.SetExtraFieldDefinitions functions to create custom fields.
- Version 7.1
- Added XML.Import.SetBaseFields and XML.Import.SetExtraField.
Blog Entries
This function is free to use.
Created 2nd February 2017, last changed 19th June 2019
XML.Import.SetBaseFields - XML.Import.SetExtraFieldDefinitions
