Re: [sqlite] Pragma setting

[Tom Weir]

As Kurt just said, it varies depending on the pragma. See the docs for 
each specific pragma in the language manual (see the URL Kurt 
specified):

eg: for PRAGMA default_synchronous :
"Query or change the setting of the "synchronous" flag in the database. 
The first (query) form will return the setting as an integer."

Some pragmas, such as show_datatypes, do not support being queried. If 
the the pragma description does not include the word "query", you 
likely cannot retrieve the current value.

Regards,

Tom

On 7-Dec-03, at 11:46 AM, Bronislav Klucka wrote:

OK, I'll try it another way: Is there any way how can I get to know 
how are
partisular pragmas set?

Brona

-----Original Message-----
From: Kurt Welgehausen [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 10:16 PM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Pragma setting
<http://www.sqlite.org/lang.html> will tell you whether a
particular pragma can be queried.  show_datatypes cannot
be queried (apparently).
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]