On Thu, 2007-07-05 at 18:26 -0300, Bruno S. Oliveira wrote:
> Hi all,
>
> I'm having problems with the sqlite3_step function.
> I have a table with only one record and then I execute the
> sqlite3_step twice (with some processing in between). In the first run
> of the function everything goes fine
On Thu, 2007-07-05 at 21:08 -0700, Dave Brown wrote:
> I am considering using FTS for a new feature. My question is:
>
> - If I use fts1 (or fts2) now, and then a new version of fts comes out which
> is not backwards compatible, will I at least be able to upgrade users by
> simply deleting the old
I am considering using FTS for a new feature. My question is:
- If I use fts1 (or fts2) now, and then a new version of fts comes out which
is not backwards compatible, will I at least be able to upgrade users by
simply deleting the old FTS table and re-building it using the new FTS
system?
In ot
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Sunday, July 01, 2007 11:11 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] sqlite testing with Boundschecker
>
> "Damian Slee" <[EMAIL PROTECTED]> wrote:
> >
> > I have done some testing with 3.2 and
Roger Binns wrote:
> is there really a native java-port of sqlite ?
There is an insane project named NestedVM that compiles C code for the
MIPS processor and then converts it to Java bytecode.
http://nestedvm.ibex.org/
It comes packaged up with a JDBC interface:
http://www.zentus.com/sqlit
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
gg wrote:
> is there really a native java-port of sqlite ?
There is an insane project named NestedVM that compiles C code for the
MIPS processor and then converts it to Java bytecode.
http://nestedvm.ibex.org/
Roger
-BEGIN PGP SIGNATURE-
V
Hi all,
I'm having problems with the sqlite3_step function.
I have a table with only one record and then I execute the
sqlite3_step twice (with some processing in between). In the first run
of the function everything goes fine, but, in the second one, it
returns SQLITE_ROW even with only one reco
DBTools Software is pleased to announce the new DBManager Professional
Enterprise Edition version 3.4.5.
This is only a bug fix without new features and recommended for users of
previous versions.
For a complete list of changes please check
http://www.dbtools.com.br/EN/article.php?id=00094.
The n
Hello,
So, I would like to take on an project to collect all the information
and restructure it in a comprehensive SQLite 3 Manual. Sqlite.org
already has (almost) all the information for the book so, if whoever has
the copyright to that material allows it, it's a matter of copying,
pasting a
> So apparently boundschecker is upset because SQLite is merely making
> a copy pointer to previously freed memory. There really is no harm
> in this. Nothing bad can happen unless the program actually tries
> to dereference the pointer - which it never does.
I don't think GCC makes this guarant
Alberto Simões <[EMAIL PROTECTED]>
wrote:
I have a big table (16 million records) and I want to perform JUST
ONCE an operation to sort by one column:
SELECT * FROM tbl ORDER BY i DESC;
Now, is it faster to perform just the select, or to do:
CREATE INDEX tmp ON tbl (i);
SELECT * FROM tbl
Hi
I have a big table (16 million records) and I want to perform JUST
ONCE an operation to sort by one column:
SELECT * FROM tbl ORDER BY i DESC;
Now, is it faster to perform just the select, or to do:
CREATE INDEX tmp ON tbl (i);
SELECT * FROM tbl ORDER BY i DESC;
Thank you
Alberto
--
Al
Hi everyone,
I'm a semi-active SQLite user and it has always bothered me how the
documentation of this brilliant tool is somewhat scattered in
sqlite.org/docs.html and in the wiki. Quite often when I try to help
other users in #sqlite IRC channel (irc.freenode.net) I know I have seen
the answ
On 05/07/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
The fact that GROUP BY follows ORDER BY, of course. You are probably not
surprised that you can't, say, put WHERE clause in front of FROM clause
or SELECT clause - why are you surprised that other clauses must also be
used in a certain order?
Jeffrey Ratcliffe
<[EMAIL PROTECTED]> wrote:
SELECT eid, P, subcase
FROM temp a1
WHERE NOT EXISTS (
SELECT *
FROM temp a2
WHERE a2.eid == a1.eid AND a2.P < a1.P
)
ORDER BY eid
GROUP BY eid;
I get a syntax error, complaining about GROUP. If I switch the ORDER
and GROUP lines, I get the desired r
Pls check if can create a normal file more than 2GB from your program
if not then some options must be missing.
regards
ragha
**
This email and its attachments contain confidential information from HUAWEI,
w
On 05/07/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Add "group by eid"
For
SELECT eid, P, subcase
FROM temp a1
WHERE NOT EXISTS (
SELECT *
FROM temp a2
WHERE a2.eid == a1.eid AND a2.P < a1.P
)
ORDER BY eid
GROUP BY eid;
I get a syntax error, complaining about GROUP. If I switch the ORDER
Jeffrey Ratcliffe
<[EMAIL PROTECTED]> wrote:
Even better. Thanks again. But in the case where there ARE duplicates:
CREATE TEMPORARY TABLE temp (eid, P, subcase);
INSERT INTO temp (eid, P, subcase) VALUES (1, 1, 'a');
INSERT INTO temp (eid, P, subcase) VALUES (1, 1, 'b');
INSERT INTO temp (eid,
Hi all,
This is with reference to the problem mentioned below:
1) I am using NTFS file system
2) I tried in windows 2000 and Windows XP
But still I am able to log only 2 GB of data. SQLite stops logging data
more than that. But it is not throwing any exception also.
Is
Hello,
I would like to give SQLite a try for an embedded system running on
Embedded Linux ARM CPU architecture. Are there any pre-compiled binaries
available?
Thanks,
Thomas
-
To unsubscribe, send email to [EMAIL PROTE
On 04/07/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
For each unique eid you look for a record with this eid where P is
smallest. Another way to express "smallest" is to say: there doesn't
exist a record with the same eid and a smaller value of P. Which is
precisely what my "not exists" clause
21 matches
Mail list logo