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

Mashiane

Expert
Licensed User
Longtime User
Update: BULK INSERTS

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

B4X:
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...

BVBuilkInserts.gif
 
Upvote 0
Top