Platforms to show: All Mac Windows Linux Cross-Platform

BuildRecordSetMBS(fieldNames() as string, values() as string) as RecordSet

Type Topic Plugin Version macOS Windows Linux iOS Targets
global method SQL MBS SQL Plugin 13.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Builds a recordset from strings.
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

See also BuildRowSetMBS for newer Xojo versions.

Some examples using this global method:

Blog Entries

The items on this page are in the following plugins: MBS SQL Plugin.


The biggest plugin in space...