Re: [sqlite] Database from scratch

2006-03-18 Thread drh
Robert Bielik <[EMAIL PROTECTED]> wrote: > I'm using the ODBC driver for SQL and I want to create a SQLite 3 db > from scratch, i.e. open a transaction, use DDL to create > tables and inserts to insert data into the tables, then commit. It seems > to work (i.e. a file is created and it has a

[sqlite] Database from scratch

2006-03-18 Thread Robert Bielik
I'm using the ODBC driver for SQL and I want to create a SQLite 3 db from scratch, i.e. open a transaction, use DDL to create tables and inserts to insert data into the tables, then commit. It seems to work (i.e. a file is created and it has a reasonable size). However, when trying to open the