2.8.15 gives 9.9
--Keith
On 8/30/05, Bob Dankert <[EMAIL PROTECTED]> wrote:
>
> Using the downloaded command-line tool for 3.2.5, I get the same :.0
> result. Using an older version which I compiled, I get 9.9, though it
> seems it should round up to 10.0?
>
> Bob
>
> Envision Information
It's not too hard.
Instantiante a static class method that matches the sqlite callback signature.
When you register the callback with sqlite, you'll want to pass in the
this pointer to the instantiated class.
Within the static class method, cast the void pointer back to the
instantiated
Sigh. Amazing what the lack of an 'out' will do to a sentence:
>I know sqlite will parse an SQL statement with running it, reporting
> any errors.
That should be:
I know sqlite will parse an SQL statement without running it, reporting
any errors.
On 5/5/05, Keith Herold <[EMAIL
I know sqlite will parse an SQL statement with running it, reporting
any errors. Is there an ODBC way of doing this? I anticipate some
users of my app replacing the SQLite back end with a different (ODBC)
database system, and I would like to check unknown SQL out before I
release it to the
Right; I was thinking of checkpoint stuff, in a sense. Smaller
transactions make things waaay slower :) .
--Keith
On Fri, 11 Mar 2005 14:03:45 -0500 (EST), Clay Dowling
<[EMAIL PROTECTED]> wrote:
>
> Keith Herold said:
> > I have a batch process that commits sets of 25 pre
Is there a difference between COMMIT and END TRANSACTION ?
I have a batch process that commits sets of 25 pre-built sql scripts
on a timed basis. I have been wrapping the execution of all 25 sets
in a single begin...end transaction set. The problem is that if any
of those scripts fails to
we would probably do switch, since there
are some frustrating bugs in VC6 that have been fixed.
I also don't know if this has been fixed already, or not.
--Keith
On Fri, 25 Feb 2005 17:31:14 -0500, Andrew Piskorski <[EMAIL PROTECTED]> wrote:
> On Fri, Feb 25, 2005 at 02:25:06PM -08
I am/was doing this in application, with 2.8.15 . I simply attached
the on-disk database to the memory, and then wrote a bunch of dump
queries to drop the memory data to disk (from the memory db
connection):
ATTACH 'C:\my_database_on_disk.sqlitedb' AS diskdb ;
Unfortunately, I don't think you
On Thu, 17 Feb 2005 16:34:07 +0100, Peter Berkenbosch <[EMAIL PROTECTED]> wrote:
> Yes :)
>
> -Oorspronkelijk bericht-
> Van: Claudio Bezerra Leopoldino [mailto:[EMAIL PROTECTED]
> Verzonden: donderdag 17 februari 2005 16:25
> Aan: SQLiter Mailing List
> Onderwerp: [sqlite] Beginner
insert. The sql scripts are inserted, one
at a time, in a transaction; each of the scripts has lots and lots of
sql in it (think of a log file).
--Keith
On Fri, 11 Feb 2005 08:15:49 -0500 (EST), Clay Dowling
<[EMAIL PROTECTED]> wrote:
>
> Keith Herold said:
> > I have a
= new.NameID ;
END ;
INSERT INTO tblNames (First, Last) VALUES ('Keith', 'Herold') ;
-- LastNameIDInserted = 1
INSERT INTO tblNames (First, Last) VALUES('Keith', 'Herold');
-- LastNameIDInserted = -1
I know about last_insert_rowid, but that doesn't tell you whether an
insert succeeded
Hi all; I have been trying to find a good XML schema for describing
databases, so that I can, among other things, produce documentation
for my database format. Is there a good (free) one already out there,
that is genarally accepted/used? I'm not looking to export data, just
the description of
I also; I sent in a couple of messages on Monday and I haven't seen them post.
--Keith
On Wed, 12 Jan 2005 09:20:13 -0700, Dennis Cote <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Yesterday I posted three messages to the mailing list. Today when I look at
> the list only the last of those three
Since EXCEPT returns the left side of a query, once duplicates are
deleted from the select on the right, how might one get the !Left AND
!Right rows, i.e., the rows which are not in *both* the left and right
selects. I had thought EXCEPT did this, but it doesn't, and I was
wondering if SQlite had
I know I can recover the last_insert_rowid() in SQLite in the SQL
query itself; is there an equivalant SQL function to sqlite_changes or
sqlite_last_statement_changes (from 2.8.15)? If, for example, an
insert doesn't take place, I get the last id of the insert *before*
this one. What I would
I am looking for some inspiration on schemas in SQLite. I am trying to
decide whether the following is a good idea, because I can't think of a way
to do this in SQLite without writing some C++ code.
I have a table that consists of warning and error messages that come from
two separate (but
Doesn't this mean select the literal value "ID"?
**
- Sounds like a Wookie; acts like mad cow.
- I'm not a professional; I just get paid to do this.
- Rules for programming:
1. Get it working, right?
2. Get it working right.
- Things
3.0 supports precompiled queries natively; is it possible to store the vm in
a resource dll or something, load it up when the application starts, and
then attach an open sqlite db to the stored vm? My impression was no, based
on the API and the lack of information on wiki and the mailing list
:14 AM
To: [EMAIL PROTECTED]
Subject: RE: [sqlite] PHP5 && SQLite3
On Tue, 19 Oct 2004, Keith Herold wrote:
>Out of curiosity, how hard would it be to build a translation layer? I
>suppose it's easier to keep both versions around, and upgrade when
>necessary, but as a techni
mp;& SQLite3
using PHP doesn't help in pure C++ desktop applications that do not run in
web-server entironments.
Mel Stober
-Original Message-
From: Craig Morrison [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 10:57 AM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] PHP5 &am
Out of curiosity, how hard would it be to build a translation layer? I
suppose it's easier to keep both versions around, and upgrade when
necessary, but as a technical problem, it's at least interesting? Only
downwardly, of course, so there would be no expectation that 2.X could use
3.X, just
For every statement; great!
--Keith
-Original Message-
From: Keith Herold [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 13, 2004 11:03 AM
To: [EMAIL PROTECTED]
Subject: [sqlite] Quick question about sqlite_trace
Does sqlite_trace fire for every sql statement in a sql_exec
Does sqlite_trace fire for every sql statement in a sql_exec, or just
for the whole sql_exec/sql_compile? I.e., suppose the call to sql_exec
is:
BEGIN TRANSACTION;
INSERT INTO tblMyDestinationTable (Dogs, Cats, FoodCosts)
SELECT *
FROM tblMyTable tmt
WHERE tmt.Foo = 'bar';
SELECT
PROTECTED]
Sent: Friday, October 08, 2004 5:59 PM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Questions about sqlite's join translation
Keith Herold wrote:
> The swiki says that making JOINs into a where clause is more
> efficient, since sqlite translates the join condition into a where
&g
Well, you can always synchronize access and share the same pointer,
right (in windows; using fork in unix is bad, presumably because fork()
just copies all the data into the child)?
It sucks if you are using sql_step, or, I imagine, precompiled queries,
though.
--Keith
The swiki says that making JOINs into a where clause is more efficient,
since sqlite translates the join condition into a where clause. It also
says that you make queries more effiecient by minimizing the number of
rows returned in the FROM clause as far to the left as possible in the
join. Does
I think you have to do some VACUUM'ing in order to shrink the database.
--Keith
-Original Message-
From: Paolo Vernazza [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 26, 2004 9:56 AM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] .db file size is not changing
Unnikrishnan Nair wrote:
I am using a temporary table for some results, and I wanted to have the
rowids reset every time the table is used, so I drop the table if it is
already created, and then recreate it and fill it with results .
I thought I could use a SELECT along the lines of
SELECT 1 FROM sqlite_master WHERE
PROTECTED]
Sent: Wednesday, August 18, 2004 11:29 AM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Rowid in VIEWs?
Keith Herold wrote:
> The short question: do (temporary) VIEW's have rowid's in SQLITE?
The short answer: no.
You don't say how you are accessing the database, but if you are usin
The short question: do (temporary) VIEW's have rowid's in SQLITE?
A small description of the problem:
I have a small database of values, where I would like users to be able
to execute simple filters (as (Key,Value) pairs) to return a subset of
the data. On occasion, the result is quite large,
Hi there one of you list admin people.
I have tried for days to unsubscribe to the mailing list at this address,
but it has not worked (I work at home now, and it is more convenient to use
my home email for sqlite). I don't know if our spam filter at work is
catching the confirmation emails and
> On Jun 20, 2004, at 9:07 PM, Darren Duncan wrote:
> down the result set would make things faster..? Wouldn't the select
> here:
>
>CREATE TABLE tmp ( flag boolean, name text );
>
>SELECT name FROM tmp WHERE flag = 1 AND name LIKE '%foo%';
>
> run faster with an index on the flag
The current cleaned-up source download is not 2.8.14, but I would like to
use 2.8.14 in an upcoming product. Does anyone have the perl code handy
(and willing to give it to me :) ) that I could use to clean up the source
code (it's for windows; I can do it myself, but it will take me a while, so
In MS SQL 2000, through the query analyzer
SELECT '500' = 500
returns 500 .
SELECT 500 = '500'
returns
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '='.
Beyond these, I have no preference on whether they are true or false; I am
less worried
As a side note, I thought that the was one of the nice things about SQL in
general, that there was no real strong ordering requirement with respect to
statements. That was why T-SQL and some of the others introduced more
procedural constructs.
Is this wrong?
--Keith
35 matches
Mail list logo