Dear Anish
I am using the same
---------------------------------------------------------------
sqlite3_open(database, &db);
sqlite3_exec(db, "PRAGMA page_size=4096", NULL, NULL, NULL);
sqlite3_exec(db, "create table t.......................
---------------------------------------------------------------
and its working the only file included is (#include "sqlite3.h")
regards,
TAMIMY
----- Original Message -----
From: "Anish Enos Mathew" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, May 22, 2006 3:49 PM
Subject: RE: [sqlite] Pragmas
>
> Hi,
> I used the following command for setting the page size.
>
> PRAGMA page_size = 4096; before the table is created.
>
> But it is showing an error, "PRAGMA undeclared". What could be the
> problem? Do I need to include any header file for it?
>
> -----Original Message-----
> From: Nemanja Corlija [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 22, 2006 1:12 AM
> To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
> Subject: Re: [sqlite] Pragmas
>
> On 5/21/06, Unit 5 <[EMAIL PROTECTED]> wrote:
>> I am a bit confused on how to change the page_size
>> using the pragma command. The documentation says:
>>
>> "The page-size may only be set if the database has not
>> yet been created."
>
> The database is created when you create first table in it. Run the
> pragma before your first CREATE TABLE query.
