Re: [sqlite] Reading pragma's results

2009-05-25 Thread João Eiras
Well, thank you all. I managed to solve the problem. It was some initialization problems with sqlite. On Mon, May 25, 2009 at 7:20 PM, João Eiras wrote: > Okay, but I'm using the latest sqlite source version 3.6 > > On Mon, May 25, 2009 at 7:17 PM, Derrell Lipman >

Re: [sqlite] Reading pragma's results

2009-05-25 Thread João Eiras
Okay, but I'm using the latest sqlite source version 3.6 On Mon, May 25, 2009 at 7:17 PM, Derrell Lipman wrote: > On Mon, May 25, 2009 at 1:10 PM, João Eiras wrote: >> Btw, the same happens with the command line sqlite program >> >> $

Re: [sqlite] Reading pragma's results

2009-05-25 Thread Derrell Lipman
On Mon, May 25, 2009 at 1:10 PM, João Eiras wrote: > Btw, the same happens with the command line sqlite program > > $ sqlite > SQLite version 2.8.17 These pragmas didn't exist six years ago when 2.8.17 was current. The only pragmas in that version are: default_cache_size

Re: [sqlite] Reading pragma's results

2009-05-25 Thread João Eiras
Btw, the same happens with the command line sqlite program $ sqlite SQLite version 2.8.17 Enter ".help" for instructions sqlite> create table t(a integer); sqlite> insert into t values(1); sqlite> select * from t; 1 sqlite> pragma page_size; sqlite> pragma page_count; sqlite> Both pragmas don't

Re: [sqlite] Reading pragma's results

2009-05-25 Thread João Eiras
On Mon, May 25, 2009 at 6:48 PM, Igor Tandetnik wrote: > "João Eiras" wrote > in message > news:e72b1b360905250934h1b39c95eycab618faca87d...@mail.gmail.com >> Sorry, wrong url... >> http://pastebin.ca/1433959 >> >> On Mon, May 25, 2009 at 5:37 PM, João

Re: [sqlite] Reading pragma's results

2009-05-25 Thread Igor Tandetnik
"João Eiras" wrote in message news:e72b1b360905250934h1b39c95eycab618faca87d...@mail.gmail.com > Sorry, wrong url... > http://pastebin.ca/1433959 > > On Mon, May 25, 2009 at 5:37 PM, João Eiras > wrote: >> Hi there. >> I'm trying the following code >>

Re: [sqlite] Reading pragma's results

2009-05-25 Thread João Eiras
Sorry, wrong url... http://pastebin.ca/1433959 On Mon, May 25, 2009 at 5:37 PM, João Eiras wrote: > Hi there. > I'm trying the following code > http://pastebin.ca/143395 > > Strangelly, both pragmas don't return any row at all ! > What am I missing ? > The same happens if I

[sqlite] Reading pragma's results

2009-05-25 Thread João Eiras
Hi there. I'm trying the following code http://pastebin.ca/143395 Strangelly, both pragmas don't return any row at all ! What am I missing ? The same happens if I open a data file on disk. Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org