SQLite enforce immediate update

I have problem regarding to enforcing immediate transaction commitment, I tried to insert 300 rows with a new transaction in each passing command, however after finishing inserting the 300 rows and calling commit command, I try to read the inserted rows and I get the result of nothing, however if I just called 'exit sub' I find all 300 records are written.

My question how to enforce transaction to commit all changes to database before calling another select command.