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 > To: "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 To: "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
Re: [sqlite] PRAGMA user_version
Walter wrote: > Thank you Igor I had the database name but did not > think of the the dot in between. Perhaps some one could update the > documentation to show this Perhaps someone could read the documentation before complaining about it. http://sqlite.org/pragma.html "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." -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] PRAGMA user_version
On Sep 3, 2011, at 8:21 PM, Walter wrote: > > Thank you Igor I had the database name but did not think of the the dot in > between. Perhaps some one could update the documentation to show this Cheers > everyone Walter Please see "PRAGMA Command Syntax" http://sqlite.org/pragma.html -j ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] PRAGMA user_version
On Sep 3, 2011, at 8:21 PM, Walter wrote: > > On 9/2/2011 11:02 PM, Walter wrote: > >> > Is there any way to get the user_version from an Attached database >> > PRAGMA attachedName.user_version; > > -- Igor Tandetnik Thank you Igor I had the database name but did not think of > the the dot in between. Perhaps some one could update the documentation to > show this Cheers everyone Walter > it is a pretty common SQL convention, using periods to separate the database_from.schema_from.table_from.column You don't have to specify the left-side qualifier if the entity on the right of the period can be located unambiguously. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] PRAGMA user_version
On 9/2/2011 11:02 PM, Walter wrote: > Is there any way to get the user_version from an Attached database PRAGMA attachedName.user_version; -- Igor Tandetnik Thank you Igor I had the database name but did not think of the the dot in between. Perhaps some one could update the documentation to show this Cheers everyone Walter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] PRAGMA user_version
On 9/2/2011 11:02 PM, Walter wrote: Is there any way to get the user_version from an Attached database PRAGMA attachedName.user_version; -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] PRAGMA user_version
Hi All Is there any way to get the user_version from an Attached database PRAGMA user_version only get it from the Opened database. If not perhaps a request for it. Thank you Walter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] PRAGMA user_version;
"Preston & Chrystie" <[EMAIL PROTECTED]> wrote: > If I have never set the user_version will the value always be 0? It will unless somebody else sets it ;-) > > I plan to start using user_version in my app, I will need to set this > value to a approprate value if it has not yet been set, and i am just > double checking that it is always 0 untill i set it. > > Anybody have a better way to hold onto a revision of the database? > The user_version pragma was added for exactly this purpose. -- D. Richard Hipp <[EMAIL PROTECTED]>
[sqlite] PRAGMA user_version;
If I have never set the user_version will the value always be 0? I plan to start using user_version in my app, I will need to set this value to a approprate value if it has not yet been set, and i am just double checking that it is always 0 untill i set it. Anybody have a better way to hold onto a revision of the database? --Preston
Re: [sqlite] PRAGMA user_version
>From memory I think it went into version 3.1. --- Randall Fox <[EMAIL PROTECTED]> wrote: > I am trying to use "PRAGMA user_version;", but it doesn't seem to work > with my version of Sqlite, 3.08. > > What version is this feature in? > > I also checked the pragma.c file, from the website CVS, and I didn't see > any notes about it being added since 3.08.. > > Thanks > > Randall Fox > > Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html
[sqlite] PRAGMA user_version
I am trying to use "PRAGMA user_version;", but it doesn't seem to work with my version of Sqlite, 3.08. What version is this feature in? I also checked the pragma.c file, from the website CVS, and I didn't see any notes about it being added since 3.08.. Thanks Randall Fox
