Platforms to show: All Mac Windows Linux Cross-Platform

BuildRowSetMBS(fieldNames() as string, values() as string) as RowSet

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

RowSet requires Xojo 2019r2 or newer.

Blog Entries

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

The biggest plugin in space...