Martin, Can you give an example on how to use this. Basically I want to see (select) only the uncommited rows.
Thanks! -Alex On Thu, Apr 17, 2008 at 11:58 AM, Ken <[EMAIL PROTECTED]> wrote: > I believe the pragma read_uncommitted only works for shared cache mode and > threads. > > You'll have to select the data from the same connection that created the > data. > > > > "Martin.Engelschalk" <[EMAIL PROTECTED]> wrote: Hi, > > there is a pragma: PRAGMA read_uncommitted = 1; > You can select the uncommitted data and show ist before commit. > > Have a look here: http://www.sqlite.org/pragma.html > > Martin > > Alex Katebi schrieb: > > Hi All, > > > > Let's say I start a transaction and do bunch of insertions etc. Before > my > > commit I like to show (select) what I have configured. > > How can I accompilish this? > > > > Thanks, > > -Alex > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > > * Codeswift GmbH * > Traunstr. 30 > A-5026 Salzburg-Aigen > Tel: +49 (0) 8662 / 494330 > Mob: +49 (0) 171 / 4487687 > Fax: +49 (0) 12120 / 204645 > [EMAIL PROTECTED] > www.codeswift.com / www.swiftcash.at > > Codeswift Professional IT Services GmbH > Firmenbuch-Nr. FN 202820s > UID-Nr. ATU 50576309 > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users