Thanks a lot .. this helped.. On Fri, Jul 3, 2015 at 10:16 PM, Simon Slavin <slavins at bigfraud.org> wrote:
> > On 3 Jul 2015, at 5:16pm, Kumar Suraj <surajnitk at gmail.com> wrote: > > > So whats the solution here. I am giving 4 statements because i need > insert > > to be transactional. Some other process could be inserting in the same db > > and so we need insert and row id values to be in one transaction. Is > there > > any other way i can achieve it. > > Just issue your SQL commands as four separate commands. The database > knows that they all came from the same connection and it will keep the > database locked for you until you COMMIT. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >