Xojo Conferences
| MBS | Oct | 2019 | Cologne | DE |
Platforms to show: All Mac Windows Linux Cross-Platform
BuildRecordSetMBS(fieldNames() as string, values() as string) as RecordSet
Function:
Builds a recordset from strings.
Example:
Notes:
First array has field names. Second array has all values.
As plugin can't access multi dimensional arrays, we have to flatten it into one dimension and concat all rows.
Returns nil on low memory.
Array sizes should be like: Ubound(values)+1 = (ubound(fieldNames)+1) * RecordCount
| Type | Topic | Plugin | Version | macOS | Windows | Linux | Console & Web | iOS |
| global method | SQL | MBS SQL Plugin | 13.0 | Yes | Yes | Yes | Yes | No |
Example:
dim names() as string = array("Firstname", "Lastname")
dim values() as string
values.append "Stefan"
values.append "Miller"
values.append "Patrick"
values.append "Maier"
dim r as RecordSet = BuildRecordSetMBS(names, values)
First array has field names. Second array has all values.
As plugin can't access multi dimensional arrays, we have to flatten it into one dimension and concat all rows.
Returns nil on low memory.
Array sizes should be like: Ubound(values)+1 = (ubound(fieldNames)+1) * RecordCount
Some examples using this method:
Blog Entries
The items on this page are in the following plugins: MBS SQL Plugin.
Links
MBS Xojo Plugins
