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

Reply via email to