B4J Question [BANanoSQL] [SOLVED] How can I achieve batch inserts?

[Mashiane]

Ola

Is it possible to execute a batch insert with BANanoSQL, for example inserting 20 records at one time? or rather a transaction mode?

Thanks.

 

[alwaysbusy]

I think alaSQL used to have some kind of transactions but removed it because of its instability

 

[Mashiane]

Update: BULK INSERTS

Found a link for bulk inserts, wow. https://github.com/agershun/alasql/issues/63

Dim ListOfAttributes As List
ListOfAttributes.Initialize
ListOfAttributes.Add(CreateMap("name":"v-model","component":"v-alert","type":"string","default":""))
Dim TableName as string = "vueattributes"
Dim rslt As String = db.ExecuteWait($"SELECT * INTO [${TableName}] FROM ?"$, array(ListOfAttributes))

It returns the number of records added, I compare this to the list size I was feeding.

Example run...