Nikki Locke <[EMAIL PROTECTED]> wrote: > > Given that I am using SQLite.Net, if I execute this pragma as the first > command > passed over the connection, before creating any tables, will it work? Or do I > really have to execute it "before creating the database"?
I think you're confusing creating the database with creating the file. When you open a non-existent db file, your file system is probably creating a file of zero size; the database hasn't been initialized yet. You can easily verify this by looking at the file size after you open() the db but before you do anything else. Regards