### DBUtils all Records in TableView

To show, using DBUtils, all records in a TableView using DBUtils, set a Limit 0 in DBUtils.ExecuteTableView.
Any other value shows the only the Limit specified.
DBUtils is only compatible with SQLite databases(status 20170228).
Examples
#Region Project Attributes
'SQLite driver
#AdditionalJar: sqlite-jdbc-3.7.2
#End Region
`Sub Process_Globals
Private gSQL As SQL
Private TableView1 As TableView
End Sub`
'List All Records
DBUtils.ExecuteTableView(gSQL, "SELECT Name FROM Name", Null, 0, TableView1)
'List 1 Record
DBUtils.ExecuteTableView(gSQL, "SELECT Name FROM Name", Null, 1, TableView1)
'List 2 Records
DBUtils.ExecuteTableView(gSQL, "SELECT Name FROM Name", Null, 2, TableView1)
Etc.
Notes
'Create the table
Dim Fields As Map
Fields.Initialize
Fields.Put("Name", "TEXT")
DBUtils.CreateTable(gSQL, "Name", Fields , "Key")
'Insert some Data
'Add Data
Dim ListOfMaps As List
ListOfMaps.Initialize
'Entry 1
Dim m As Map
m.Initialize
m.Put("Name", "Name 1")
ListOfMaps.Add(m)
'Entry 2
Dim m As Map
m.Initialize
m.Put("Name", "Name 2")
ListOfMaps.Add(m)
'Insert the Data as ListOfMaps into the Table
DBUtils.InsertMaps(gSQL, "Name", ListOfMaps)

Changed: , Category: Database, File: T6C181M1305.htm, ID: 1305