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
Function: 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 RowSet = BuildRowSetMBS(names, values)
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

RowSet requires Xojo 2019r2 or newer.

Blog Entries

Feedback, Comments & Corrections

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

The biggest plugin in space...




Links
MBS FileMaker Plugins

Start Chat