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
Function: 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 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

Feedback, Comments & Corrections

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

The biggest plugin in space...

MBS FileMaker blog

Start Chat