Re: [sqlite] How to set pragma page_size

2007-03-15 Thread Ken
Thanks DRH... That worked. Ken [EMAIL PROTECTED] wrote: Ken wrote: > How does one set the page_size ? > > according to the documentation > "The page-size may only be set if the database has not yet been created. > " > > So how do you execute the pragma prior to creating the DB?

Re: [sqlite] How to set pragma page_size

2007-03-15 Thread drh
Ken <[EMAIL PROTECTED]> wrote: > How does one set the page_size ? > > according to the documentation > "The page-size may only be set if the database has not yet been created. > " > > So how do you execute the pragma prior to creating the DB? without calling > sqlite3_open to get a

[sqlite] How to set pragma page_size

2007-03-15 Thread Ken
How does one set the page_size ? according to the documentation "The page-size may only be set if the database has not yet been created. " So how do you execute the pragma prior to creating the DB? without calling sqlite3_open to get a DB handle that is needed to call prepare/step ?