> I have a Delphi SQLite wrapper. > It can Open database, run sql-s, etc. > > But I don't know, how to I set page size, because when I do open in > database, the pragma is not working, and when I try to exec sql before > open database, the wrapper is say: database not opened... > > Anybody have an example in any language in any wrapper ? I want to see > how to you do !
Page size can only be set before any tables have been added to the database as far as I can tell The pragma command is: PRAGMA page_size=XXXX (Where XXXX is the size, 4096 or something) Perhaps a better idea would to look at some of the componant sets out there, Something like the http://www.aducom.com/sqlite/ will automatically create the DB if ity doesn exist and then you can make sure you ExecSQL the PRAGMA the first chance you have (If you run PRAGMA page_size without a setting, it will tell you what your size is. Note: If you set page size then close down DB without creating a table it is RESET back to 1024)
