[sqlite] How to create a transaction in SQLite.

[Sami Islam]

Hello,
I am using this in my VBCode to create a transaction and commit/rollback

1. Execute the string "BEGIN"
2. Execute 1000 insert statements in a table
3. If no error in VB then execute the string "COMMIT"
4. else execute the strint "ROLLBACK"

Is this the correct syntax?

Regards,

Sami