Android Question DBUtils.InsertMaps

[sivakrith]

Hello,
Need to insert / update multiple table(s) using DButils.Insertmaps. Will the below procedure work ? Should take care of database transaction too.

lm_map1.Initialize
lm_map1.put("field1", ls_field1)
lm_map1.put("field2", ls_field2)
lst1.add(lm_map1)

lm_map2.Initialize
lm_map2.put('field21', ls_field21)
lm_map2.put('field22', ls_field22)
lst2.add(lm_map2)

If Dbutils.insertmaps(sql, "table1", lst1) = True Then
    If Dbutils.Insertmaps(sql, "table2", lst2) = True Then
        // Message success
    End If
End If

How to rollback table1 records, if some db errors occurs while inserting in table2 ?

Happiness Always
BKR Sivaprakash

 

[Erel]

DBUtils.InsertMaps is a utility that comes to help you. There are cases where it doesn't help and this is one such case. Don't use it.

Create a single transaction, insert all the records and complete the transaction.

You can see how InsertMaps is implemented (unzip the b4xlib file).