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. -- Nemanja Corlija <[EMAIL PROTECTED]> The information contained in, or attached to, this e-mail, contains confidential information and is intended solely for the use of the individual or entity to whom they are addressed and is subject to legal privilege. If you have received this e-mail in error you should notify the sender immediately by reply e-mail, delete the message from your system and notify your system manager. Please do not copy it for any purpose, or disclose its contents to any other person. The views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of the company. The recipient should check this e-mail and any attachments for the presence of viruses. The company accepts no liability for any damage caused, directly or indirectly, by any virus transmitted in this email. www.aztecsoft.com
