Re: [sqlite] PRAGMA user_version of attached database
> Thanks. Sorry I missed that. And, yeah.. it's right there at the top. With a pretty diagram, too. I know. For some reason, I thought it would be specified with ATTACH itself. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] PRAGMA user_version of attached database
Thanks. Sorry I missed that. Marc > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Peter Aronson > Sent: Monday, March 12, 2012 1:43 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] PRAGMA user_version of attached database > > "A pragma may have an optional database name before the pragma name. > The database name is the name of an ATTACH-ed database or it can be > "main" or "temp" > for the main and the TEMP databases. If the optional database name is > omitted, "main" is assumed. In some pragmas, the database name is > meaningless and is simply ignored." > > Thus, PRAGMA .user_version; > > Peter > > > > > From: Marc L. Allen <mlal...@outsitenetworks.com> > To: "sqlite-users@sqlite.org" <sqlite-users@sqlite.org> > Sent: Mon, March 12, 2012 10:27:54 AM > Subject: [sqlite] PRAGMA user_version of attached database > > When multiple databases are attached to the main, is there a way to get > the user_version of any of the attached DBs? > > Thanks, > > Marc > > -- > ** > * * * > * Marc L. Allen * "... so many things are * > * * possible just as long as you * > * Outsite Networks, Inc. * don't know they're impossible." * > * (757) 853-3000 #215 * * > * * * > * mlal...@outsitenetworks.com * -- The Phantom Tollbooth * > * * * > ** > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] PRAGMA user_version of attached database
"A pragma may have an optional database name before the pragma name. The database name is the name of an ATTACH-ed database or it can be "main" or "temp" for the main and the TEMP databases. If the optional database name is omitted, "main" is assumed. In some pragmas, the database name is meaningless and is simply ignored." Thus, PRAGMA .user_version; Peter From: Marc L. Allen <mlal...@outsitenetworks.com> To: "sqlite-users@sqlite.org" <sqlite-users@sqlite.org> Sent: Mon, March 12, 2012 10:27:54 AM Subject: [sqlite] PRAGMA user_version of attached database When multiple databases are attached to the main, is there a way to get the user_version of any of the attached DBs? Thanks, Marc -- ** * * * * Marc L. Allen * "... so many things are * * * possible just as long as you * * Outsite Networks, Inc. * don't know they're impossible." * * (757) 853-3000 #215 * * * * * * mlal...@outsitenetworks.com * -- The Phantom Tollbooth * * * * ** ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] PRAGMA user_version of attached database
When multiple databases are attached to the main, is there a way to get the user_version of any of the attached DBs? Thanks, Marc -- ** * * * * Marc L. Allen * "... so many things are * * * possible just as long as you* * Outsite Networks, Inc. * don't know they're impossible." * * (757) 853-3000 #215 * * * * * * mlal...@outsitenetworks.com * -- The Phantom Tollbooth * * * * ** ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users