--- 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.
>
> I know this can be done from the shell, but as of yet, I can't
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
it's
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 ad
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 sour
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 ro
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 t
"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?
>
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...
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 th
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 07 October 2007 17:39
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Re: Callback fonction really not flexible to use
Igor Tandetnik a écrit :
[EMAIL PROTECTED] wrote:
Here a sample (in c) of the use i
Here's something from some code I was working on this morning that hopefully
will help
sqlite3_stmt* pStatement;
char* acQuery = sqlite3_mprintf("SELECT feedurl FROM feeds WHERE pageurl =
'%q'",sUrl.c_str());
int nError = sqlite3_prepare_v2(m_pDB,acQuery,-1,&pStatement,NULL);
while (nError == SQLI
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 t
--- 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.
> >
>
[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).
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 ca
15 matches
Mail list logo