On Tue, Jun 19, 2012 at 08:16:37PM +0200, Patrik Nilsson scratched on the wall:
> 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.
No, but following the standard of every other PRAGMA, this does work:
PRAGMA main.table_info( test );
See the syntax diagrams here: http://sqlite.org/pragma.html
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have it,
but showing it to the wrong people has the tendency to make them
feel uncomfortable." -- Angela Johnson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
