Platforms to show: All Mac Windows Linux Cross-Platform
Required plugins for this example: MBS SQL Plugin
You find this example project in your Plugins Download as a Xojo project file within the examples folder: /SQL/BuildRecordSetMBS test
This example is the version from Fri, 27th Dec 2012.
Project "BuildRecordSetMBS test.xojo_binary_project"
Class App Inherits Application
Const kEditClear = "&Löschen"
Const kFileQuit = "Beenden"
Const kFileQuitShortcut = ""
End Class
Class Window1 Inherits Window
EventHandler Sub Open()
dim names() as string = array("Firstname", "Lastname")
dim values() as string
values.append "Stefan"
values.append "Müller"
values.append "Patrick"
values.append "Maier"
dim r as RecordSet = BuildRecordSetMBS(names, values)
break // inspect in debugger if you like
if r.RecordCount <> 2 then break
if r.EOF then break
if r.IdxField(1).Name <> names(0) then break
if r.IdxField(2).Name <> names(1) then break
if r.IdxField(1).StringValue <> values(0) then break
if r.IdxField(2).StringValue <> values(1) then break
r.MoveNext
if r.EOF then break
dim v3 as string = r.IdxField(1).StringValue
dim v4 as string = r.IdxField(2).StringValue
if v3 <> values(2) then break
if v4 <> values(3) then break
r.MoveNext
if not r.EOF then break
Break // done with tests
End EventHandler
End Class
MenuBar MenuBar1
MenuItem FileMenu = "&Ablage"
MenuItem FileQuit = "#App.kFileQuit"
MenuItem EditMenu = "&Bearbeiten"
MenuItem EditUndo = "&Rückgängig"
MenuItem UntitledMenu1 = "-"
MenuItem EditCut = "&Ausschneiden"
MenuItem EditCopy = "&Kopieren"
MenuItem EditPaste = "&Einfügen"
MenuItem EditClear = "#App.kEditClear"
MenuItem UntitledMenu0 = "-"
MenuItem EditSelectAll = "&Alles auswählen"
End MenuBar
End Project
The items on this page are in the following plugins: MBS SQL Plugin.