Alex Katebi wrote:
>    Can you give an example on how to use this. Basically I want to see
> (select) only the uncommited rows.
> 

You will have to keep track of the rows that have been changed yourself.

You can have SQLite do it for you if you create a change_log table and 
then setup triggers to add the rowids of any rows modified during the 
transaction. You clear this table at the beginning of your transaction. 
The triggers will insert rows for each change to the table. At the end 
of the transaction you can select all the rows from the main table that 
have their rowids stored in the change_log table.

If you want to get fancier you can look at this page for more ideas 
http://www.sqlite.org/cvstrac/wiki?p=UndoRedo

HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to