| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
JSON.Import.SetExtraField
Sets the extra field to add to all tables.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| JSON | 14.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "JSON.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 JSON.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( "JSON.Import.SetExtraField"; "test"; "Hello"; "VARCHAR") ]
See also
Release notes
- Version 14.2
- Added JSON.Import.SetExtraField and JSON.Import.SetBaseFields functions.
This function is free to use.
Created 10th May 2024, last changed 11st May 2024
