[sqlite] [sqlite]: How does a transaction work

[jayanth KP]

Hi,
    I wanted to know how does a transaction work..

In the following example shown below, where is the transaction updated. Is it 
in the memory or some temp file or is it directly written to the database file. 
Please give more internal details on this.

sqlite_exec_printf(pDBHandle,"begin transaction;", 0, 0, NULL);

sqlite_exec_printf(pDBHandle, "update table1 set c1 = 1",0,0,0,NULL);
sqlite_exec_printf(pDBHandle, "update table2 set c1 = 1",0,0,0,NULL);
sqlite_exec_printf(pDBHandle, "update table3 set c1 = 1",0,0,0,NULL);
sqlite_exec_printf(pDBHandle, "update table4 set c1 = 1",0,0,0,NULL);

sqlite_exec_printf(pDBHandle,"COMMIT;", 0, 0, NULL);



Regards
Jayanth