"Iulian Popescu" <[EMAIL PROTECTED]> writes: > How can I set the pragma values - is this something that can be done at > build time or is it only possible at runtime by executing the command > (before running any SELECT statements)?
I don't have the sqlite3 source in front of me, but in sqlite2, you could modify the function sqlite_open() and issue something like db->flags |= SQLITE_ShortColNames; In sqlite3, there's probably an sqlite3_open() function where you could do something similar, but I'm only guessing without having the source available. I'm not sure why you'd need to modify the sqlite3 source, though. All you have to do is issue the pragma from your application after opening a database. It need only be issued once per database, so it can just be part of your procedure for opening a database. Derrell
