B4J Question DBUtils: Broken?

[LWGShane]

TheSQL.InitializeSQLite(File.DirApp, "db.db", True)

  
Dim Fields As Map
Fields.Initialize
Fields.Put("Name", "TEXT")

Dim ListOfMaps As List
ListOfMaps.Initialize
Dim M As Map
M.Initialize
M.Put("Name", "Olimar")
M.Put("Name", "Louie")
M.Put("Name", "Alph")
ListOfMaps.Add(M)
        
DBUtils.CreateTable(TheSQL, "Name", Fields , "Key")
DBUtils.InsertMaps(TheSQL, "Name", ListOfMaps)
DBUtils.ExecuteTableView(TheSQL, "SELECT Name FROM Name", Null, 1, TableView1)

Code doesn't insert all three keys. Already tried a "For" statement. Doesn't work. TableView1 only displays Alph.

 

[Eumel]

You overwrite the key "Name" always, so only the last record will insert.

Dim M As Map
M.Initialize
M.Put("Name", "Olimar")
ListOfMaps.Add(M)
Dim M As Map
M.Initialize
M.Put("Name", "Louie")
ListOfMaps.Add(M)
Dim M As Map
M.Initialize
M.Put("Name", "Alph")
ListOfMaps.Add(M)

 

[LWGShane]

You overwrite the key "Name" always, so only the last record will insert.

Dim M As Map
M.Initialize
M.Put("Name", "Olimar")
ListOfMaps.Add(M)
Dim M As Map
M.Initialize
M.Put("Name", "Louie")
ListOfMaps.Add(M)
Dim M As Map
M.Initialize
M.Put("Name", "Alph")
ListOfMaps.Add(M)

Tried it, and it still displays the last record.

Code:

Dim Fields As Map
Fields.Initialize
Fields.Put("Name", "TEXT")

Dim ListOfMaps As List
ListOfMaps.Initialize
Dim M As Map
M.Initialize
M.Put("Name", "Olimar")
ListOfMaps.Add(M)
Dim M As Map
M.Initialize
M.Put("Name", "Louie")
ListOfMaps.Add(M)
Dim M As Map
M.Initialize
M.Put("Name", "Alph")
ListOfMaps.Add(M)


DBUtils.CreateTable(TheSQL, "Name", Fields , "Key")
DBUtils.InsertMaps(TheSQL, "Name", ListOfMaps)
DBUtils.ExecuteTableView(TheSQL, "SELECT Name FROM Name", Null, 1, TableView1)

I honestly have no idea why it still displays the last record.

 

[rwblinn]

Hi,

change the Limit from 1 to 0 in ExecuteTableView and the records are shown. Just tested in a sample app.

DBUtils.ExecuteTableView(TheSQL, "SELECT Name FROM Name", Null, 0, TableView1)

 

[LWGShane]

@rwblinn
@Eumel

It works! Thanks! (I'm switching to DBUtils for all my SQL needs; and after this test, DBUtils is freaking awesome and super easy.)