Wow! Am I impressed!
A while back I initiated the email concerning the large number of
compiler warnings that were being generated when I attempted to
compile the SQLite source code using either the Visual Studio 2005
compiler or using XCode 2.2 (gcc 4). This sparked off some
acrimonious
the
actual intent raises some concerns.
-ken
On 29-Oct-05, at 12:56 PM, [EMAIL PROTECTED] wrote:
Ken & Deb Allen <[EMAIL PROTECTED]> wrote:
vdbeapi.c
e:\SQLITE\327\Source\vdbeapi.c(55) : warning C4244: 'return' :
conversion from 'i64' to 'int', possible loss of data
e:\SQLITE\327\Source
but should the code not be commented
concerning such conversions, and the conversion be made explicit?
-ken
This would be more effective if it were also available for MacOS and
Linux.
-ken
On 20-Aug-05, at 5:32 AM, Ralf Junker wrote:
Hello Clark Christensen,
SQLiteSpy executes the query "select date('2005-08-19');" with no
problems. SQLiteSpy is a free SQLite3 database manager and is
n why these errors may be reported by the
SQLITE .Net Data Provider?
By the way, I am using the SQLITE 3.2.2 DLL file for Windows
downloaded from the SQLITE web site and (I believe, since I am home
now) version 1.7 of the .Net Data Provider.
-ken
Database creation results;
MSDE dat
Will declaring the column as VARCHAR not achieve the same thing? Does
SQLITE not translate VARCHAR to TEXT, rather than numeric?
-ken
On 21-Jun-05, at 5:10 AM, D. Richard Hipp wrote:
On Tue, 2005-06-21 at 00:13 -0400, Tito Ciuro wrote:
Hello,
When I add text to the database, it's getting
ed to issue a SQL statement
like "UPDATE Customers SET Name = xxx, Age = yyy WHERE CustomerID =
AND ChangeFlag = fff", and the code would check to ensure that
exactly one record was modified.
-ken
On 17-May-05, at 4:46 PM, Will Leshner wrote:
I develop a database wrapper for SQLit
for
formatting the data for display, but where I need to manipulate the
data I still retrieve the 'raw' integer value and convert it as I
require.
-ken
On 22-Apr-05, at 9:03 AM, [EMAIL PROTECTED] wrote:
"msaka msaka" <[EMAIL PROTECTED]> writes:
how can i use timestamp valu
When can we expect a 3.2.2 release that includes this correction? I am
working on a database that depends on 64-bit integer values.
-ken
On 15-Apr-05, at 7:35 AM, D. Richard Hipp wrote:
On Fri, 2005-04-15 at 10:53 +0100, Richard Boulton wrote:
I'm running the latest sqlite 3.2.1 command line
), and then timing the SELECT/JOIN.
-ken
On 15-Apr-05, at 6:15 AM, Ken & Deb Allen wrote:
I cannot speak for SQLITE for certain, but I know with a number of
commercial RDBMS packages the index is not used unless it contains a
sufficient degree of distribution. Microsoft SQL Server, for exa
removed from the second table, and
therefore the records will not be part of the JOIN in the future. In
some databases this may be faster than using an index; I have not
experimented with this in SQLITE, however.
-ken
On 15-Apr-05, at 4:30 AM, msaka msaka wrote:
i dont need working with dates and times..
of the database file by releasing unused 'pages', but does
that not require that data be moved around so that the empty pages are
at the end of the database file?
Thanks in advance for any and all assistance.
-Ken
, and in the callback handling each of the
rows from the SELECT have the code issue another SELECT and have a
second callback handle the results from that query?
-ken
On 8-Apr-05, at 2:46 PM, Jay Sprenkle wrote:
select_stmt = db.execute("SELECT * FROM people")
# use some, but not all o
name IN ('Table12', 'Table2', ...)" and check that the resulting count
is the expected value.
-ken
On 9-Apr-05, at 6:18 AM, Jochen Müller wrote:
Hello!
I am new to SQL and have a simple question concerning sqlite. I am
using the functions sqlite3_open, sqlite3_get_table and
sqlite3_
disappeared
The address is www.sqlite.org.
Eric Pankoke
Founder
Point Of Light Software
http://www.polsoftware.com/
-Original Message-
From: Ken Cooper [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 1:38 AM
To: [EMAIL PROTECTED]
Subject: [sqlite] www.sqlite.com has disappeared
Anyone else experiencing this?
ore results, and therefore can order my selects. Right now I'm
operating under the assumption that they filter based on the intersect,
querying from left to right.
Thanks,
Ken
The '.'s below should be ellipses.
-Original Message-
From: Ken Cooper [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 15, 2004 1:56 PM
To: [EMAIL PROTECTED]
Subject: [sqlite] Efficient select for multiple ids
I am implementing a virtualized listview on the result of a query
, or does
someone have a better suggestion? I remember seeing something referring to
this issue posted awhile back, but I'm having trouble locating it (googling
on 'where' and 'or' and 'in' is rather painful.).
Ken
ess experiments I've been running, and
I've seen comments on this list suggesting the latter for BLOBs. Are there
specific tuning tweaks I can make to improve my results?
Thanks,
Ken Cooper
the max length is #define'd per-system. No need to penalize people whose OSs
aren't so draconian.
-Ken
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
specified group.
Perhaps you just want:
SELECT user_id FROM users
WHERE user_id NOT IN
(SELECT user_id FROM grp_user WHERE group_id = 42)
-Ken
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
ction is finished running.
If the function doesn't expect to modify it, it can declare it "const". If
it does expect to modify it, then you shouldn't ALSO modify it. =)
-Ken
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
that triggered it, in my opinion.
-Ken
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
essage from DRH a few days ago, this is necessary to avoid
syncing:
On Mar 18, 2004, at 12:14 PM, D. Richard Hipp wrote:
> To run a query within a transaction, you also have to compile
> it within a transaction. To run a query outside of a transaction
> it should be comp
more than in other databases I'm
used to, rather than just adding indexes you *think* should help and
trusting the database to do the "right" thing.
-Ken
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
ng things like table-level or row-level locking, rather than
database-level like SQLite) and SQLite puts no work into it.
This assumes that multiple users will be reading *and* writing. If they're
all just reading, SQLite might be fine.
-Ken
--
e the
expertise (or desire) to implement the date/time functions in a really
correct way, though they may expect them to *work* in a correct way.
-Ken
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
ift the date by that amount. For example:
>
> SELECT datetime('2003-12-04 09:27:00', '00:01:21');
> 2003-12-04 09:28:21
>
That sounds convenient but potentially dangerous - does it understand leap
years/seconds, for example? And various o
uation, creating
INSERT/UPDATE triggers to make sure the integrity of the column is
maintained.
-Ken
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
r.
It looks like it's trying to subscribe you, not unsubscribe you.
Double-check that you're sending it the right instructions.
-Ken
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hi,
Is SQLite currently capable of using more than one index in a query? I'm
adding indexes to a table, trying to optimize a query, and I only ever see
one index in the "EXPLAIN" output.
-Ken
-
To unsubscribe, e-ma
> -Original Message-
> From: Matt Sergeant [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 02, 2004 4:26 AM
> To: Williams, Ken
> Cc: SQLite-Users (E-mail)
> Subject: Re: [sqlite] Error on commit
>
>
> On 29 Jan 2004, at
();
$dbh->do("BEGIN");
add_lots_of_rows_to_lots_of_tables();
$dbh->do("COMMIT");
Thanks,
-Ken
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 22, 2004 5:57 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Functions & Keywords
>
>
> Williams, Ken wrote:
> >
> > Hmm - al
> -Original Message-
> From: Dennis Cote [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 22, 2004 5:23 PM
> To: Williams, Ken; [EMAIL PROTECTED]
> Subject: Re: [sqlite] Functions & Keywords
>
>
> Again, see the SQLite source, in particular the file func
> -Original Message-
> From: Dennis Cote [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 22, 2004 1:58 PM
> To: Williams, Ken; 'Drew, Stephen'; [EMAIL PROTECTED]
> Subject: Re: [sqlite] Functions & Keywords
>
>
> > Please excuse the silly
giving you
> a prompt. This works, mostly. But I think there are some bugs
> outstanding against this. The code there definately needs to be
> cleaned up.
Cool, that seems to work. Thanks.
-Ken
-
To unsubsc
red preferences file or something?
-Ken
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 14, 2004 9:22 AM
> To: Williams, Ken
> Cc: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Optimizing a query
>
>
> Williams, Ken wrote:
> >
> > So, no w
of the query criteria...
} elsif ($o_entry > $p_entry {
next P_INDEX;
}
}
}
-Ken
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
d
with other databases I've used, like Postgres, MySQL, and Oracle. Are there
any plans/desires to fix this, or is it considered something that just comes
with the "lightweight" territory?
-Ken
-
To unsubscribe, e
t;,"1CO",1917,9
> just how does a person handle this case?
With the Text::CSV_XS module, available on CPAN.
-Ken
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
FROM output, tokens,
>WHERE output.sentence=tokens.sentence
> AND output.stop=tokens.position
> AND output.type='prop'
> AND tokens.postag='RP');
Aha, of course! Thanks. This ought to work.
-Ken
t
...> SET stop=stop+1
...> WHERE type='prop'
...> AND sentence=(SELECT sentence FROM tokens
...> WHERE tokens.postag='RP')
...> AND stop=(SELECT position FROM tokens)
...> WHERE tokens.postag='RP');
-Ken
Hi,
Is it possible in SQLite to update a table using information from another
table? Something like the "UPDATE ... FROM" syntax in Postgres, or "UPDATE
table1, table2 ..." syntax in MySQL is what I'm looking for.
If not, can someone suggest
501 - 546 of 546 matches
Mail list logo