Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

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 Console & Web iOS
global method SQL MBS SQL Plugin 13.0 Yes Yes Yes Yes No
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 RecordSet = BuildRecordSetMBS(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

Some examples using this method:

Feedback, Comments & Corrections

CloneRecordSetMBS(rec as RecordSet) as RecordSet
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
global method SQL MBS SQL Plugin 12.5 Yes Yes Yes Yes No
Function: Creates an in memory copy of the RecordSet.
Notes: This copied record set can be used instead of the original one and even after the original database connection is closed.

Feedback, Comments & Corrections

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




Links
MBS Xojo blog