I have a table in which I am inserting songs after syncing the device.
So I have a situation like this
.
.
2000 entries
commit 1
.
.
5000 entries
commit 2
.
.
(condition)
After syncing the device I have a condition.Based on (condition)
I want to do either commit 1
which inserts 2000 entries or commit 2
which inserts all 5000 entries(including commit 1). Is it possible in sqlite?
On searching I found about savepoints. Is this what I need? or should I use nested begin - commit
transactions?
PS : I am a newbie to sqlite.
Aucun commentaire:
Enregistrer un commentaire