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
>

Reply via email to