SQL Rollback

I've had a couple of queries about our pseudo 'transaction' system...   probably better referred to as "SQL Rollback" since it could quite easily be ported to any database engine, ACID or otherwise.

Anyway - I though a little demo of what it can do would be helpful.

This demo runs through a sequence of (currently) 9 statements and then rolls the whole lot back.  Each statement is executed as the page request runs.

At each stage a little method dumps the data from the tables out for you to see, highlighting any changes since the last time it ran.  Each statement itself is also dumped out so you can see what's going on.

So here it is: live demo of (software) SQL Rollback...