Re: [sqlite] How to I set pragma page_size ?

> I have a Delphi SQLite wrapper. > It can Open database, run sql-s, etc. > > But I don't know, how to I set page size, because when I do open in > database, the pragma is not working, and when I try to exec sql before > open database, the wrapper is say: database not opened... > > Anybody

[sqlite] Possible bug

I tried to download sqlite3-3.1.1beta.bin.gz to see if this problem still exists, but my browser and wget both report that the file is empty. The following is from version 3.1.0. It is perhaps an unusual use of a correlated subquery. If it's a bug that someone wants to address, let me know and

[sqlite] Renaming existing tables using SQLite 3.0.7?

Does the ALTER TABLE renaming work for version 3.0.7? I want to rename existing tables, but I also don't want to use non-production ready libraries in my application. Is the 3.1.0 ALPHA version the only version where you can use ALTER TABLE for table renaming? If so, how stable is the 3.1.0 ALPHA

Re: [sqlite] [OT] SQL: limit a query by sum(val)?

At 6:50 PM +0100 2/11/05, Philipp Knüsel wrote: select * from t1 where period < '2003-1' order by period desc: -- val periodsum(val) -- --- -- 15 2002-4 15 -- 10 2002-3 25 -- 5 2002-2 30 -- 15 2002-1 45 -- 10 2001-4 -- 5 2001-3 I need only the first

RE: [sqlite] basic sql question: Is there a way of entering multiple rows in a table?

I would use attach database, and then use an insert select.. Ie. Attach database db2; Insert into table1 select * from db2.table2; Hope this helps... Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.256.3780

[sqlite] basic sql question: Is there a way of entering multiple rows in a table?

Hi,   I know I can create a temporary table and insert them from that or use a for loop in C and get it to update the table one row at a time, but is there a ‘nicer’ way??    I basically have a string of text which I’ve obtained from another (remote) Sqlite database which I want to

Re: [sqlite] Solaris 2.5 compilation

On Fri, Feb 11, 2005 at 01:04:40PM -0500, Christopher R. Palmer wrote: > I had problems compiling the 3.0.8 version of sqlite on my Solaris box. > The version of "awk" on Solaris does not support the gsub function which What about using nawk or gawk? nawk at least is in the default Solaris

[sqlite] Solaris 2.5 compilation

I had problems compiling the 3.0.8 version of sqlite on my Solaris box. The version of "awk" on Solaris does not support the gsub function which makes the generation of opcodes.c and opcodes.h fail. The use of gsub is actually quite simple and I created a little patch that using sed in the

[sqlite] how to use multiple tables in an update or delete?

Is there any way to use multiple tables in an update or a delete? Most databases support doing something like: Update table1 join table2 on table1.index = table2.index set table1.column = value The only way I know around it is to use a subselect in the filter for the update/delete, but

[sqlite] [OT] SQL: limit a query by sum(val)?

Hello SQLite-Users This is offtopic, but as I would like to use it within SQLite... so let's try: I would like to reduce the resultset of a query like using limit. But instead of using the number of records by the sum of values. A small example: create table t1 (val int, period text); insert into

[sqlite] [OT] SQL: limit a query by sum(val)?

Hello SQLite-Users This is offtopic, but as I would like to use it within SQLite... so let's try: I would like to reduce the resultset of a query like using limit. But instead of using the number of records by the sum of values. A small example: create table t1 (val int, period text); insert into

Re: [sqlite] Reset values if insert fails

The output is an SQL script, formatted for later insert, so I don't have access to the return values, and can't use the API. The update names table (a temporary table) is used to maintain the current ID's so that the dependent inserts don't require all the information leading up to the current

[sqlite] Wiki -- a few links vandalized -- needs revert

FYI; I have yet to learn much about Wiki's but I understand they can be easily reverted to undo vandalism -- and someone seems to have vandalized the last few links of page: http://www.sqlite.org/cvstrac/wiki to point to inappropriate content. Donald

RE: [sqlite] VACUUM question

A! very helpful indeed. thank you so much. Regards, Uriel_Carrasquilla Rani Pinchuk

RE: [sqlite] VACUUM question

Probably you didn't realize that it is part of the SQL that SQLite understands: http://www.sqlite.org/lang_vacuum.html Rani On Fri, 2005-02-11 at 15:28, [EMAIL PROTECTED] wrote: > > > My understanding is that a stupid question is the one not asked. > Excuse my ignorance, but what is VACUUM? >

Re: [sqlite] VACUUM question

VACUUM was the function for remove unused space in file after many operation on this, delete,update,etc i think it is that [EMAIL PROTECTED] a écrit : My understanding is that a stupid question is the one not asked. Excuse my ignorance, but what is VACUUM? I've seen a couple of e-mails go

RE: [sqlite] VACUUM question

My understanding is that a stupid question is the one not asked. Excuse my ignorance, but what is VACUUM? I've seen a couple of e-mails go back and forth and I feel silly not to know what you guys are talking about. Regards, Uriel_Carrasquilla

[sqlite] How to I set pragma page_size ?

Hi ! I have a Delphi SQLite wrapper. It can Open database, run sql-s, etc. But I don't know, how to I set page size, because when I do open in database, the pragma is not working, and when I try to exec sql before open database, the wrapper is say: database not opened... Anybody have an example

RE: [sqlite] VACUUM question

On Fri, 2005-02-11 at 10:29 +0200, Cariotoglou Mike wrote: > It has been my experience that, when two processes have the same db > open, and one of them does a VACUUM, and the other tries to update, > The database gets corrupted. Not easy to simulate, but has happened at > least twice, in fact it

Re: [sqlite] Does the list in tokenize.c represent the entire set of keywords?

On Thu, 2005-02-10 at 00:59 -0800, [EMAIL PROTECTED] wrote: > I found this list of keywords in tokenize.c. A little search-and-replace-- > replacing TK_ with ', etc.--and it makes a nice set for validating keywords. > > > Two questions: Am I safe in assuming this represents the entire set of >

RE: [sqlite] VACUUM question

It has been my experience that, when two processes have the same db open, and one of them does a VACUUM, and the other tries to update, The database gets corrupted. Not easy to simulate, but has happened at least twice, in fact it has been the only way I managed to corrupt a database. Comments,