Hello
I was wondering if SQLite 2.8.x was able to update a column automatically
when performing either INSERT or UPDATE, or if this can only be done with
triggers in 3.x?
For instance, when adding a record, I need to have a counter in the third
column be incremented by one:
insert
The lock4-1.3 problem happens ONLY when lock4.test is run after lock3.test:
=
[EMAIL PROTECTED] arcturus | sqlite.arcturus.gcc > ./testfixture
../sqlite/test/lock4.test
lock4-1.1... Ok
lock4-1.2... Ok
lock4-1.3... Ok
The string "integer value too large to represent" is not found in
sqlite sources, so I assume it is an error in either in Tcl or the tcl
test harness.
I have no idea why the checksum of the databases in malloc2-1.1.28.5
is different, or whether it is harmless.
As for the malloc2.1.5 failure, as
Ahh, that's it.
On the ODBC driver information page I see "So far it has been tested
with SQLite 2.8.17 and SQLite 3.3.13"
Darn!
Thanks Joe!
On 8/3/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
> rtrim was introduced on 17-Mar-07, and was in the sqlite 3.3.14 release.
>
> http://www.sqlite.org/cvs
rtrim was introduced on 17-Mar-07, and was in the sqlite 3.3.14 release.
http://www.sqlite.org/cvstrac/chngview?cn=3698
What sqlite version is your ODBC driver?
select sqlite_version();
--- Mitchell Vincent <[EMAIL PROTECTED]> wrote:
> If I use sqlite3.exe to execute the query "Select
> cus
If I use sqlite3.exe to execute the query "Select
customer_id,customer_number FROM customers where customer_number !=
rtrim(customer_number);" it works great but as soon as I run that
query through using the SQLite ODBC driver (using the latest
available) I get "no such function: rtrim (1)"
I thou
-Original Message-
From: Luís Santos [mailto:[EMAIL PROTECTED]
Sent: Friday, August 03, 2007 2:41 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Strange behaviour on Update
Hi, Ppl
We have found a strange behaviour on SQLite 3.4.1 (We have also tested against
versions 3.0.8, 3.2.5 a
update test set FieldOne = '1';
--- Luís Santos <[EMAIL PROTECTED]> wrote:
> sqlite> CREATE TABLE test (
>...> id INT NOT NULL,
>...> FieldOne TEXT NOT NULL,
>...> FieldTwo TEXT,
>...> "1" TEXT
>...> );
> sqlite> insert into t
Luís Santos wrote:
When we create a field with a name composed exclusively of numeric
algarisms, we cannot perform an update.
We have only noticed this odd behaviour because of a NOT NULL field.
See the code example:
sqlite> CREATE TABLE test (
...> id INT NOT NULL,
...>
At 11:23 03/08/2007 -0700, Robert Simpson wrote:
Download the System.Data.SQLite.DLL I maintain from
http://sqlite.phxsoftware.com
Thanks, I'll check it out :-)
G.
-
To unsubscribe, send email to [EMAIL PROTECTED]
--
On Fri, Aug 03, 2007 at 11:38:57AM -0700, Joe Wilson wrote:
> > Of course I'm not. The PHP4 module uses sqlite2.x, and - besides - it
>
> :-)
>
> "Of course"? That's rich.
"Of course" - just because I haven't any possibility to do that.
> > OK, I'll try to ask maintainers about that.
>
> Goo
Hi, Ppl
We have found a strange behaviour on SQLite 3.4.1 (We have also tested
against versions 3.0.8, 3.2.5 and 3.4.0)
When we create a field with a name composed exclusively of numeric
algarisms, we cannot perform an update.
We have only noticed this odd behaviour because of a NOT NULL fi
--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> On Fri, Aug 03, 2007 at 09:27:22AM -0700, Joe Wilson wrote:
>
> > You are not checking the return code of the sqlite3 connection close.
>
> Of course I'm not. The PHP4 module uses sqlite2.x, and - besides - it
:-)
"Of course"? That's rich.
I
On Fri, 3 Aug 2007 09:35:49 -0400, you wrote:
>Sounds like Wikipedia. I understand that Wikipedia's software is Open
>Source and available. Do you know of other Wiki servers that would suffice
>or be more on target?
There are several wiki software packages avaialble.
The wiki server behind
> -Original Message-
> From: Gilles Ganault [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 03, 2007 11:12 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] [VC++ 6] Error compiling VBified source
>
> At 09:53 03/08/2007 -0700, Joe Wilson wrote:
> >This has come up before on the l
At 09:53 03/08/2007 -0700, Joe Wilson wrote:
This has come up before on the list. The instructions are wrong:
Sorry, should have thought someone had already tried.. and failed :-/
Browsing through the archives, it looks like the code might not be 100%
reliable, so I'll probably look for anoth
./testfixture test/select1.test
> Is there a way to run a single test of my choice?
Luggage? GPS? Comic books?
Check out fitting gifts for grads at Yahoo! Search
http://search.yahoo.com/search?fr=oni_on
> -Original Message-
> From: Stephen Sutherland [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 03, 2007 10:33 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] How to Speed of Inserts
>
[snip]
>
>So it makes me a bit concerned that when I have to drop my
> XML repository wit
1. Use bind vars... prepare the statement once, execute it many times
binding values each time.
1a. Drop the index.
2. Use a transaction.
3. Commit every . In your case with only
10,000 recs, I would commit only at the very end.
4. Build the index at the end.
Really, 10k recs should insert in
Regarding:
"Is there away to maximize this speed dramatically ...?"
Yes, be sure to surround your inserts with a single transaction (i.e.,
"BEGIN", "END").
If you were doing millions of inserts, you might want to use a new
transaction after each, say, 5 thousand inserts.
If you don't ca
Hi
Here's My Situation:
-
I have an XML file which contains user created data. It can have maybe 10,000
or more nodes. The XML needs to be queried infrequently for use in the
application, in a way that lends itself more to SQL. For example the only qu
On Fri, Aug 03, 2007 at 09:27:22AM -0700, Joe Wilson wrote:
> You are not checking the return code of the sqlite3 connection close.
Of course I'm not. The PHP4 module uses sqlite2.x, and - besides - it
doesn't return any value when using sqlite_close.
> I have no idea if the PHP sqlite3 wrapper
Is there a way to run a single test of my choice?
Victor Secarin
Joe Wilson wrote:
Can you post the output for the failed tests?
i.e.:
footest-13.1...
Expected: [10]
Got: [0]
--- Victor Secarin <[EMAIL PROTECTED]> wrote:
Hello, everyone. I just started to look at the software and
--- Gilles Ganault <[EMAIL PROTECTED]> wrote:
> As I'd like to be able to build my own SQLite DLL for use with Visual
> Basic Classic, I followed Todd Tanner's instructions at
> www.tannertech.net/sqlite3vb/ to make the (few) required changes and
> compile with Visual C++ 6.0.
This has co
Here are the fulltest errors I get trying to build sqlite 3.4.1 with the
included gcc on Enterprise 3, 4 and Fedora 5.
After building tcl8.4.7 and installing it in /usr/local, I was able to
configure with "--with-tcl=/usr/local/lib" and build the two libraries
completely and then run the fulltes
Mark and Richard:
Thank you all for your well considered comments. I've got enough
information to decide to spend some time evaluating SQLite as a replacement
DB. I'll cook up some test code as a next step. The example code will be
a good starting point.
The comments about the added safety of
--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> > Your trace seems to indicate it has 20 or so open
> > connections to the same database file in the same process.
>
> I think, at last I've traced the problem:
>
> One of the scripts doesn't make use out of database contents at all. But at
> t
Thanks Igor! Good point on the invoice_number index - I didn't have my
brain turned on there!
On 8/2/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Mitchell Vincent <[EMAIL PROTECTED]>
> wrote:
> > Is there any way to determine if a query is using an index or not? In
> > PostgreSQL the "explain
On Fri, Aug 03, 2007 at 06:42:39AM -0700, Joe Wilson wrote:
> Why do you think that the sqlite connection closes itself automatically?
> Did you examine the PHP wrapper code to verify it closes each connection
> in a timely fashion?
No, I read it months ago in some manual/tutorial - but cannot fi
Hello
As I'd like to be able to build my own SQLite DLL for use with Visual
Basic Classic, I followed Todd Tanner's instructions at
www.tannertech.net/sqlite3vb/ to make the (few) required changes and
compile with Visual C++ 6.0.
As a test, after just making those changes in the amalgamated
On 8/3/07, john s wolter <[EMAIL PROTECTED]> wrote:
> Sounds like Wikipedia. I understand that Wikipedia's software is Open
> Source and available. Do you know of other Wiki servers that would suffice
> or be more on target?
John,
sqlite.org has a built-in wiki. There's a link on the front page
On 8/3/07, Andrew Finkenstadt <[EMAIL PROTECTED]> wrote:
> I expect that for most of us, we prefer to get our information "pushed" to
> us rather than having to go check laboriously each of the subject area's
> forums that we are interested in.
>
> Life is too short, otherwise.
>
Amen! :)
--
Je
Joe Wilson wrote:
--- [EMAIL PROTECTED] wrote:
Joe Wilson <[EMAIL PROTECTED]> wrote:
--- John Stanton <[EMAIL PROTECTED]> wrote:
Sqlite3 will get into a tangle with certain sequences where it does not
accept a semicolon as a terminator or obey a CTL c.
To reproduce:
1. build sqlite3 wi
Hi,
When I create a 3.4.1 SQLite database on Red Hat (2.6.9 kernel) and
try to create a table, I get a "database is locked" error. I don't
have any problem with a non-NFS filesystem, and I also don't have any
problem with version 3.3.3.
Does anyone have any hints, or any thoughts on changes that
Igor Tandetnik wrote:
Paul Harris <[EMAIL PROTECTED]> wrote:
anyway, this is what i'm trying to do:
eg 1
select @somevar := column1 from table1;
update table2 set column2 = @somevar;
update table2 set column2 = (select column1 from table1);
Igor Tandetnik
A note to the original poster.
Paul Harris wrote:
On 03/08/07, Nikola Miljkovic <[EMAIL PROTECTED]> wrote:
[In the message "Re: [sqlite] Re: Re: how do i declare and use variables in sqlite?" on
Aug 3, 11:47, "Paul Harris" writes:]
create temporary table vars (name text, value something);
--
insert into vars set name="x",
Scott Derrick uttered:
are you saying this is a memory leak?
sqlite never gives back the unused memory?
No, libc never gives back the memory.
It is not leaked because the malloc implementation keeps a reference to
all the free'd heap memory in tracking it for future requests.
Christian
Is there a roadmap of major planned features in upcoming releases? I didn't
see anything on the wiki or site..
Thanks,
Sam
---
We're Hiring! Seeking a passionate developer to join our team building
products. Position is in the Washington D.C. metro are
john s wolter wrote:
SQLite.org in my opinion, needs to have online community forms. I first
used majordomo ten years ago which is like the list manager being used for
sqlite-users@sqlite.org but in today's Internet it can be mistaken for
SPAM. I do not know if SQLite would qualify because of t
--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> On Wed, Aug 01, 2007 at 03:04:35PM -0700, Joe Wilson wrote:
>
> > Maybe the php wrapper is not closing sqlite connections correctly
> > (or at all).
> >
> > See if you can get the stack traces of all threads in the php process
> > 162 via psta
john s wolter wrote:
I have an old Clipper DBF type application that has worked well but times
changed and changed long ago. The feature of this DBF, non-GUI, text
oriented, application is that it is mostly a list lookup application with
few DB changes. A separate Admin program does list manage
Sounds like Wikipedia. I understand that Wikipedia's software is Open
Source and available. Do you know of other Wiki servers that would suffice
or be more on target?
On 8/3/07, Paul Harris <[EMAIL PROTECTED]> wrote:
>
> On 03/08/07, john s wolter <[EMAIL PROTECTED]> wrote:
> > Wiki's. I have
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > --- John Stanton <[EMAIL PROTECTED]> wrote:
> > > Sqlite3 will get into a tangle with certain sequences where it does not
> > > accept a semicolon as a terminator or obey a CTL c.
> >
> > To reproduce:
> >
> > 1. build s
I expect that for most of us, we prefer to get our information "pushed" to
us rather than having to go check laboriously each of the subject area's
forums that we are interested in.
Life is too short, otherwise.
Hello,
I recently got some debug logs from my users that indicate problems
with VACUUM command. The error message is:
SQL logic error or missing database (1).
This is using the latest SQLite (3.4.1) Windows DLL.
I tried to rule out my coding mistakes, at the moment of the problem
there is only
Joe Wilson <[EMAIL PROTECTED]> wrote:
> --- John Stanton <[EMAIL PROTECTED]> wrote:
> > Sqlite3 will get into a tangle with certain sequences where it does not
> > accept a semicolon as a terminator or obey a CTL c.
>
> To reproduce:
>
> 1. build sqlite3 without readline support.
> 2. run sqlite
"john s wolter" <[EMAIL PROTECTED]> wrote:
> I have an old Clipper DBF type application Clipper DBF file
> indexes are a simple key-value and a pointer into a DBF file's
> records. That is why these lookups are so fast
>
> I am of the opinion that full SQL engine's set based extraction
Bharath Booshan L
<[EMAIL PROTECTED]> wrote:
Consider the following schema
Create table Library(LibraryID INTEGER PRIMARY KEY AUTOINCRMENT,
LibraryName
TEXT);
Create table Book(LibraryID INTEGER REFERENCES Library, BookID TEXT
PRIMARY
KEY, BookName TEXT);
Now I believe Library(LibraryID) is aut
Paul Harris <[EMAIL PROTECTED]> wrote:
anyway, this is what i'm trying to do:
eg 1
select @somevar := column1 from table1;
update table2 set column2 = @somevar;
update table2 set column2 = (select column1 from table1);
Igor Tandetnik
--
Hi Chase,
it connects fine. no errors. but then i try to create a temp
table (which, like i said, works if the db is local) it fails
immediately with SQLITE_BUSY "database is locked".
It's some Mac vs SQLite bug. You can recompile SQLite to fix it. See
the old post below. And search the
50 matches
Mail list logo
