> 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:
nal 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:
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 dat
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
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 optio
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
-
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 do
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
documentati
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/l
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
"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 a
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
>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,
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
14 matches
Mail list logo
