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.