Check out example codes for "Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0". It will help you in understanding the concepts better.

Code Example 1

The cause of the error is often mismatch of BEGIN and COMMIT as clearly stated by the error. This means using:

Begin Transaction
  Begin
    -- your query here
  End
commit

instead of

Begin
  Begin
    -- your query here
  End
commit

omitting Transaction after Begin causes this error!

Learn ReactJs, React Native from akashmittal.com