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
[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).
--- 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.
> >
>
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
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
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...
"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?
>
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
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
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
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
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
12 matches
Mail list logo