Hi All, I use "PRAGMA table_info" to check my tables at start up and if the table columns are the need of updating (adding or removal) I do that.
After a redesign of how the databases are managed this doesn't work anymore. Instead of using several database connections, I use one. The cleaned up the code looks better and is less error prone to select the wrong database connection, but it comes with a prize: "PRAGMA table_info" does not take databases as table names. "test" works as an argument, but "main.test" doesn't. Best Regards, Patrik patrik@debian:~$ ~/Projects/DMemory/trunk/shell/sqlite3 /home/files/test.dmemory "PRAGMA table_info(page)" 0|id|integer|0||1 1|type|integer|0||0 2|sortorder|integer|0||0 3|width|integer|0||0 4|height|integer|0||0 5|sizedata|integer|0||0 6|deleted|integer|1|0|0 7|viewwidth|integer|1|0|0 8|fontname|text|0||0 9|fontsize|integer|1|0|0 10|comment|text|0||0 11|data|blob|0||0 patrik@debian:~$ ~/Projects/DMemory/trunk/shell/sqlite3 /home/files/test.dmemory "PRAGMA table_info(main.page)" Error: near ".": syntax error patrik@debian:~$ ~/Projects/DMemory/trunk/shell/sqlite3 /home/files/test.dmemory "create table testa(a integer)" patrik@debian:~$ ~/Projects/DMemory/trunk/shell/sqlite3 /home/files/test.dmemory "PRAGMA table_info(testa)" 0|a|integer|0||0 patrik@debian:~$ ~/Projects/DMemory/trunk/shell/sqlite3 /home/files/test.dmemory "PRAGMA table_info(main.testa)" Error: near ".": syntax error patrik@debian:~$ ~/Projects/DMemory/trunk/shell/sqlite3 /home/files/test.dmemory "create table main.testb(a integer)" patrik@debian:~$ ~/Projects/DMemory/trunk/shell/sqlite3 /home/files/test.dmemory "PRAGMA table_info(testb)" 0|a|integer|0||0 patrik@debian:~$ ~/Projects/DMemory/trunk/shell/sqlite3 /home/files/test.dmemory "PRAGMA table_info(main.testb)" Error: near ".": syntax error patrik@debian:~$ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users