Re: [sqlite] PRAGMA user_version of attached database

2012-03-12 Thread Marc L. Allen
> 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

Re: [sqlite] PRAGMA user_version of attached database

2012-03-12 Thread Marc L. Allen
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: R

Re: [sqlite] PRAGMA user_version of attached database

2012-03-12 Thread Peter Aronson
"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

Re: [sqlite] PRAGMA user_version

2011-09-03 Thread Igor Tandetnik
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

Re: [sqlite] PRAGMA user_version

2011-09-03 Thread Jay Kreibich
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"

Re: [sqlite] PRAGMA user_version

2011-09-03 Thread Mr. Puneet Kishor
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

Re: [sqlite] PRAGMA user_version

2011-09-03 Thread Walter
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

Re: [sqlite] PRAGMA user_version

2011-09-02 Thread Igor Tandetnik
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

Re: [sqlite] PRAGMA user_version;

2006-05-31 Thread drh
"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

Re: [sqlite] PRAGMA user_version

2005-05-06 Thread Dan Kennedy
>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