Re: [sqlite] Renaming existing tables using SQLite 3.0.7?

2005-02-12 Thread chorlya
ALTER TABLE (you can only rename tables at the moment) is only available in 3.1.x and as you can tell from the version number/name it is still officially unstable. chorlya On Fri, 11 Feb 2005 14:36:38 -0700, Dave Furey <[EMAIL PROTECTED]> wrote: > Does the ALTER TABLE renaming work for version

RE: [sqlite] VACUUM question

2005-02-12 Thread D. Richard Hipp
On Fri, 2005-02-11 at 06:11 -0500, D. Richard Hipp wrote: > 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

Re: [sqlite] Possible bug

2005-02-12 Thread Dan Kennedy
> 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. I get that too. Not sure why, the file is there on the server. > The following is from version 3.1.0. It is perhaps an > unusual use of a correlated

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

2005-02-12 Thread Marcelo Zamateo
Hi I'm very interested in "runing-functions"! If the order is a problem, it seems to me that can be solved adding one more level of subqueries: SELECT val, period FROM ( SELECT val, period, running_total(val) AS runner FROM ( SELECT val, period FROM t1 ORDER BY perio

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

2005-02-12 Thread Stefan Radig
Hi, I have released a new version of my task tracking software Yatt. It's based on SQLite. The new version adds a bunch of new features including user management from the html interface. You can find it on www.yatt.de. It's freeware. It's currently using SQLite 2.8.x. I am thinking about upgra

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

2005-02-12 Thread Ulrik Petersen
Hi Stefan, > Hi, > > I have released a new version of my task tracking software Yatt. It's > based on SQLite. > The new version adds a bunch of new features including user management > from the > html interface. You can find it on www.yatt.de. It's freeware. > > It's currently using SQLite 2.8.x.

Re: [sqlite] Yatt Task Tracker

2005-02-12 Thread Stefan Radig
Hi Ulrik, thanks for your reply. The way you describe sounds reasonable. If there is no such tool, yet, I will do it. I just thought that this could be a general tool interesting for many people, as in my understanding it does not depend at all on the content/scheme of the database. Stefan On Sat,

[sqlite] Re: [Bulk] Re: [sqlite] Re: [Bulk] Re: [sqlite] How sqlite3_column_double works?

2005-02-12 Thread Marcelo Zamateo
Dennis Cote wrote: If you can tell us what CPU and compiler you are using, we may be able to help. I use 486 and above CPU and RosAsm PEs builder (GPL, http://www.RosAsm.org) on win OS. And i do not compile sqlite but just use provided dll. Thank you. Marcelo. --

Re: [sqlite] VACUUM question

2005-02-12 Thread Derrell . Lipman
"D. Richard Hipp" <[EMAIL PROTECTED]> writes: > While on the airplane, I was able to reproduce the problem > and confirm that it is possible to corrupt a database > as described above. I've just checked in a tentative fix. > After some more testing, I will do a new release, probably > 3.1.2 (stab