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


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


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.
FieldType The SQL field type.
Default is "VARCHAR" for a text field.
"VARCHAR" Optional


Returns OK or error.


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.


Set extra field:

Set Variable [ $r ; Value: MBS( "XML.Import.SetExtraField"; "test"; "Hello"; "VARCHAR") ]

See also

Release notes

Blog Entries

This function is free to use.

Created 2nd February 2017, last changed 19th June 2019

XML.Import.SetBaseFields - XML.Import.SetExtraFieldDefinitions