Kurt Welgehausen wrote: > 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.
Thanks. I've done the test you suggested, and the file is indeed of zero length until the first table is created (at which point I assume the database is created as well). -- Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming http://www.trumphurst.com/
