[sqlite] Callback fonction really not flexible to use

2007-10-07 Thread [EMAIL PROTECTED]
hello, Here a sample (in c) of the use i would like to do with sqlite fucntion1() call fonction2() where is sqlite3_exec() Callback function is the function3() and i would like to add data in an array, which is retuned to function1() after the call of function(2). How i

[sqlite] Re: Callback fonction really not flexible to use

2007-10-07 Thread Igor Tandetnik
[EMAIL PROTECTED] wrote: Here a sample (in c) of the use i would like to do with sqlite fucntion1() call fonction2() where is sqlite3_exec() Callback function is the function3() and i would like to add data in an array, which is retuned to function1() after the call of function(2).

Re: [sqlite] SELECT crashes with small cache?

2007-10-07 Thread Joe Wilson
--- Joe Wilson <[EMAIL PROTECTED]> wrote: > --- Richard Klein <[EMAIL PROTECTED]> wrote: > > I am seeing SQLite crashing during execution > > of a SELECT statement when I make the page > > cache very small (40 pages). > > > > When I bump the cache up to 50 pages, the > > problem goes away. > > >

Re: [sqlite] Re: Callback fonction really not flexible to use

2007-10-07 Thread [EMAIL PROTECTED]
Igor Tandetnik a écrit : [EMAIL PROTECTED] wrote: Here a sample (in c) of the use i would like to do with sqlite fucntion1() call fonction2() where is sqlite3_exec() Callback function is the function3() and i would like to add data in an array, which is retuned to function1() after

[sqlite] any way to SELECT the 100th-104th row of a table?

2007-10-07 Thread Adam Megacz
Hello. This is probably a stupid question, but... Is there any way to include some phrase in a SELECT clause that will match only the Nth-Mth rows of a table, for some values of N and M? Note that ROWID isn't what I'm looking for -- if you delete rows from a table the ROWID no longer matches

Re: [sqlite] any way to SELECT the 100th-104th row of a table?

2007-10-07 Thread Vitali Lovich
The only way I can think of doing it without modifying the table (i.e. adding a rowid column that's updated on every delete) is to select all the rows on the table and then increment count for every step that returns a row. Adam Megacz wrote: Hello. This is probably a stupid question, but...

Re: [sqlite] any way to SELECT the 100th-104th row of a table?

2007-10-07 Thread Cory Nelson
"LIMIT 4 OFFSET 100" at the end of the select. On 10/7/07, Adam Megacz <[EMAIL PROTECTED]> wrote: > > Hello. This is probably a stupid question, but... > > Is there any way to include some phrase in a SELECT clause that will > match only the Nth-Mth rows of a table, for some values of N and M? >

Re: [sqlite] any way to SELECT the 100th-104th row of a table?

2007-10-07 Thread miguel manese
select * from table limit (n-1),(m-n) n-1 because it is 0-based http://www.sqlite.org/lang_select.html On 10/8/07, Adam Megacz <[EMAIL PROTECTED]> wrote: > > Hello. This is probably a stupid question, but... > > Is there any way to include some phrase in a SELECT clause that will > match only

Re: [sqlite] any way to SELECT the 100th-104th row of a table?

2007-10-07 Thread Peter Bierman
At 3:00 PM -0700 10/7/07, Adam Megacz wrote: Hello. This is probably a stupid question, but... Is there any way to include some phrase in a SELECT clause that will match only the Nth-Mth rows of a table, for some values of N and M? Note that ROWID isn't what I'm looking for -- if you delete

[sqlite] troubles w/ sqlite on AIX 5.3

2007-10-07 Thread Keith Godfrey
Greetings, I need to compile and run a program on an AIX box and then get the data back onto a linux machine for processing. I'm using sqlite3 as an embedded database (excellent software, btw). Unfortunately, this "easy" task has proved a tad bit complicated. Compiling the regular 3.5.1

[sqlite] 'dump' from the C API

2007-10-07 Thread Keith Godfrey
Hello, Does anyone know how to do a database dump from the C API? I'm linking to sqlite3.o (the amalgamated file) and was hoping to open a database and dump the contents to an sql file. I know this can be done from the shell, but as of yet, I can't get the shell running on AIX. Thanks in

[sqlite] Re: 'dump' from the C API

2007-10-07 Thread Igor Tandetnik
Keith Godfrey <[EMAIL PROTECTED]> wrote: Does anyone know how to do a database dump from the C API? I'm linking to sqlite3.o (the amalgamated file) and was hoping to open a database and dump the contents to an sql file. The code to sqlite3 command line utility is provided. You can see how