Re: [sqlite] PRAGMA user_version of attached database

[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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA user_version of attached database

[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: 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

[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 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

Re: [sqlite] PRAGMA user_version

[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 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

[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"   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

[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 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

[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 
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

[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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA user_version;

[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 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]>

Re: [sqlite] PRAGMA user_version

[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 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