Are you entering this SQL in the sqlite console app? If not, the problem might be that the app/page you are using is starting its own transaction implicitly, and sqlite does not support (last i checked) nested transactions.
Are you entering this SQL in the sqlite console app? If not, the problem might be that the app/page you are using is starting its own transaction implicitly, and sqlite does not support (last i checked) nested transactions.