Ken, In setting up sample code I have found a problem, in that the update connection was (depending on some buggy code) sometimes being opened "READ ONLY". Having corrected this I can get through 3 inserts before an error occurs "contraints failed". From what I can determine so far it looks like the records inserted during this loop are not available for re reading, I imagine this is caused by the default not making these records available until the COMMIT. Looks like some further reading for me.
So thank you muchly for responding to my email, to this point, it is appreciated. Colin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
