{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 The star\" 的问题《SQL cursors in android》','https://www.manongdao.com/q-713587.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
Suppose I run some query and get a cursor which I want to use to update the entries in the database. What happens if the database is updated while the cursor is not closed? For example, suppose the cursor is pointing at the 1st entry in the result set and I run a query that updates the 10th element. Does the current cursor reflect those changes?
相关问题
- How can I create this custom Bottom Navigation on
- SQL join to get the cartesian product of 2 columns
- sql execution latency when assign to a variable
- Bottom Navigation View gets Shrink Down
- Difference between Types.INTEGER and Types.NULL in
You need to call
cursor.requery()in order to reload changes from the database.The cursor is a copy of the results in memory, so you can modify the database at will. Since it's a copy, it won't reflect any changes - you'd need to requery for that.
However, it is absolutely imperative that you close it as soon as possible, to save memory and to make your app not crash when you switch activities.