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
sitenetworks.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 > >

Re: [sqlite] PRAGMA user_version of attached database

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

[sqlite] PRAGMA user_version of attached database

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

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

[sqlite] PRAGMA user_version

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

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

[sqlite] PRAGMA user_version;

2006-05-31 Thread Preston & Chrystie
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

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

[sqlite] PRAGMA user_version

2005-05-06 Thread Randall Fox
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