Android Question DBUtils.UpdateRecord

S

sivakrith

Member
Licensed User
Longtime User
1. I need to update multiple records using dbutils.UpdateRecord. Should I use multiple lines for the same, like this ?
B4X: 
lm_where as map
lm_where. initialize
lm_where.put("key1", keyvalue1)
dbutils.updaterecord(sql, 'table1', 'field1', 'value1', lm_where)
dbutils.updaterecord(sql, 'table1', 'field2', 'value2', lm_where)

2. How to update multiple tables with multiple fields using dbutils.UpdateRecord ? Of course need to check for any dberrors while updating the values ? ie should rollback all the updates if any errors occurs.
 
Sort by date Sort by votes

udg

Expert
Licensed User
Longtime User
To update multiple fields of the same record(s), just use:
B4X: 
' updates multiple fields in a record
' in the Fields map the keys are the column names
Public Sub UpdateRecord2(SQL As SQL, TableName As String, Fields As Map, WhereFieldEquals As Map)

Based on the criteria exposed in the WhereFieldEquals, the above will update a set of records (from zero to n).
You could copy (and rename) any function you find in DbUtils; once it's in your code module you can extend, modify, put logs..
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar Threads

P
  • Question
Android Question How to rename mysql database table using jRDC2 with B4A?
Replies
4
Views
902
josejad
S
  • Locked
Java Question DBRequestManager update multiple records
Replies
2
Views
954
Erel
S
  • Question
Android Question DBUtils.InsertMaps
Replies
1
Views
1K
Erel
  • Question
Android Question How to use DBUtils.DeleteRecord(Starter.SQL1,"Students", !?)
Replies
3
Views
2K
Theera
S
  • Question
Android Question SQL and B4xTable updating
Replies
8
Views
2K
rodmcm
R
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…