[sqlite] BUG (?) foreign_keys=on/off within a transaction

Hi, the documentation states that ALTER TABLE ... RENAME ops do not update the name of a referenced table if foreign_keys=off has been set previously. This is only true if no enclosing transaction exists, otherwise foreign_keys=off is ignored. Is this a bug or a misunderstnding on my side?

Re: [sqlite] SQLite gives Access Violation in Windows

Hi, Am Mittwoch, 12. Dezember 2007 schrieb CAVALO SCHMIDT: > Ok, I'm sending to you a zip file with the Pelles C project, together > with the database (a small test database, with a key1 with 2 values > [which doesn't throw errors] and a key2 with six values [which throws the > error]); note that,

Re: [sqlite] journal - "Unable to open the database file"

Hi, Am Samstag, 10. März 2007 13:26 schrieb [EMAIL PROTECTED]: > purpose. Where do I find out more about "anonymous mapped > objects" for windows? ot sure if this is what John wanted to suggest: http://msdn2.microsoft.com/en-us/ms810613.aspx Note that you can create a mapping using the systems

Re: [sqlite] Need a wince test

Hi, Am Donnerstag, 21. Dezember 2006 04:03 schrieb [EMAIL PROTECTED]: > My compiler does not define CP_OEM. Can somebody please tell me > what the literal value of that macro is? I think, the name of the constant is CP_OEMCP, its value is 1. Don't have a CP_OEM on my disk. - Uwe

Re: [sqlite] any data access and retrieval engine?

Am Sonntag, 22. Oktober 2006 17:10 schrieb Sarah: > Hi,all > > First of all, I want to thank all the guys on this mailing list for their > warm help. > > After 1 more month of work, I finally make SQLite work on my embedded > environment. SQLite is really great! Many thanks,Drh. > > But, due to

Re: [sqlite] Version 3.1.6

Hi, Am Donnerstag, 17. März 2005 15:45 schrieb [EMAIL PROTECTED]: > I agree. [snip] I disagree. make doc works fine w/o the patch. Regrads Uwe