You Need to bind for each insert, Sqlite does not bind by address it does a
copy.
You'll need to populate your variables inside the loop then bind then step:
prepare_v2
for(i = ...) {
assign Variables to be bound.
sqlite bind for each variable/column
step
}
finalize/reset
HTH
So I am thinking to have the bindColumns the tcpAcclRec before the for loop
so no need to bind the column every single insert.
So I took out the bindColumns ....for tcpAcclRec in the insert function and
move right after the begin transaction as below